JobRunStage table
The JobRunStage table contains details of the processing of every stage in all job runs.
Column name | Column type code | Description |
---|---|---|
RUNID | SK | The foreign key to the job run in the JobRun table. |
STAGEID | SK | The foreign key to the stage in the JobStage
table. The combination of RUNID and STAGEID is unique. |
StageStartTimeStamp | Tim | The time that the stage started. |
StageEndTimeStamp | Tim | The time that the stage finished. If the stage is still running, this column is set to null. |
LastUpdateTimeStamp | Tim | The time that this row in the table was last updated. |
ElapsedRunSecs | Int | The length of time in seconds that the stage ran for. The length of time is calculated from the StageStartTimeStamp and the StageEndTimeStamp columns. |
StageStatus | Ref | The status of the stage. See the StageStatusRef view for possible values. |
NumInstances | Int | For parallel jobs, the number of instances of
the stage that were used. For server jobs the number of instances
is always 1. The NumInstances column shows how many entries there are in the InstancePidList and InstanceCPUList columns. |
InstancePidList | 512 | A comma-separated list of process IDs. |
InstanceCPUList | 512 | A comma-separated list of the CPU time used, in milliseconds, by the instances of the stage in each of the processes in the InstancePidList column. |
TotalCPU | Int | The total of the CPU time, in milliseconds, for all entries in the InstanceCPUList column. |