Task executions table
This page describes how to use the task executions table to understand and troubleshoot your jobs in Upsolver.
The system information in Upsolver is designed to help you to monitor and troubleshoot your jobs, by providing internal insights. Jobs are divided into various tasks, with each task responsible for working with data, performing maintenance work, and more. This section describes the task execution table to help understand your jobs.
The task executions table enables you to monitor the execution of the tasks that run your jobs and maintain your tables. To monitor and troubleshoot your jobs, run the following query:
SELECT * FROM logs.tasks.task_executions;
The following three sections describe the task executions table:
- 2.Stage names: SQLake operations comprise multiple stages that execute tasks to complete a job. This section describes each of these stages that can be found in the
stage_namefield. This can help you to better understand the progress of your jobs and identify the status of each stage.
- 3.Task event types: Each stage is a logical grouping of one or more tasks. This section describes the types of tasks that can be executed, along with a description of the task event types found in the
Each record within the
task_executionstable describes a task being executed. The following is a list of the fields for each task:
This section describes each of these stages that can be found in the
The following table describes the types of tasks that can be executed, along with a description of the task event types found in the