Viewing Task History

Tasks enable scheduled execution of SQL code. A Directed Acyclic Graph (DAG) of tasks executes the SQL code defined in a root task and a set of child tasks, organized by their dependencies. For more information on tasks, see Introduction to Tasks.

In Snowsight, you can view the task history across your account. You can also examine the task history for a specific task, and view tasks as directed acyclic graphs (DAGs). .. note:

Task history data is only available if the task has been executed in the last 7 days.
Additionally, only a role that has the minimum required privileges to query the TASK_HISTORY table function can explore tasks in Snowsight.

In this Topic:

Task Graph

Task graphs depict executions of a root task and child tasks in DAG format. You can perform the following actions with task graphs:

  • Display task information, including status by root task and selected child task.

  • Examine task graphs, which are drawn from parent to child tasks.

  • Select task elements to view additional details.

Snowsight task graph example with annotations.

To view task graphs:

  1. In the Snowsight navigation menu, click Data » Databases.

  2. In the right pane, using the object explorer, navigate to a database and schema.

  3. For the selected schema, select and expand Tasks.

  4. Select a task. Task information is displayed, including Task Details, Graph, and Run History sub-tabs.

  5. Select the Graph tab. The task graph appears, displaying a hierarchy of child tasks.

  6. Select a task to view its details.

Run History

Task run history includes details about each execution of a given task. You can view the scheduled time, the actual start time, duration of a task and other information.

Snowsight task history page with annotations for each section.

For each instance, you can view the following:

  • Scheduled start time: When is the task next scheduled to run.

  • Status: Status of the most recent run.

  • Duration: Amount of time, in seconds, for the most recent run.

  • Query: View the task query profile or task statements in a worksheet.

To view the run history:

  1. In the Snowsight navigation menu, click Data » Databases.

  2. In the right pane, using the object explorer, navigate to a database and schema.

  3. For the selected schema, select and expand Tasks.

  4. Select a task. Task information is displayed, including Task Details, Graph, and Run History sub-tabs.

  5. Select the Run History tab.

Account Level Task History

Task history displays task information at the account level, and is divided into three sections:

  • Selection (1) - Defines the set of task history to display, and includes types of tasks, date range and other information

  • Histogram (2) - Displays a bar graph of task runs over.

  • Task list (3) - a list of selected tasks.

Snowsight task history page with annotations for each section.

To view account level task history:

  1. In the Snowsight navigation menu, click Activity » Task History. The Task History pane displays and includes a display by day of all tasks and skipped tasks for the date range selected.

  2. Click Date Range and select a date range from yesterday, to all time or a custom range to narrow or expand the task set.

  3. Click Status to filter by task status including: All, Succeeded, Failed, or Canceled tasks.

  4. Click Database and select a database to filter tasks by that database.

  5. Click Schema to select All, or enter a schema name to filter by that schema.

The histogram displays a list of task runs, broken down by date, divided into Succeeded, Failed or Skipped categories. Beneath the histogram a list of all tasks is displayed.

Further refine task lists, or examine task details by:

  • Using the Search button to search for a specific task in the list.

  • Selecting a bar in the histogram to list only the selected range.

  • Clicking anywhere in a task row to examine Task Details, Graph or Run History.

Back to top