SQL-DMO
Job Execution Status Constants (SQLDMO_JOBEXECUTION_STATUS)
Job execution status constants define the running state for a Microsoft® SQL Server™ Agent job.
| Constant | Value | Description |
|---|---|---|
| SQLDMOJobExecution_BetweenRetries | 3 | Job is waiting on a job step retry attempt. |
| SQLDMOJobExecution_Executing | 1 | Job is executing. |
| SQLDMOJobExecution_Idle | 4 | Job is idle, awaiting next scheduled execution. |
| SQLDMOJobExecution_PerformingCompletionActions | 7 | All executable job steps have completed. Job history logging is being performed. |
| SQLDMOJobExecution_Suspended | 5 | Job is suspended. |
| SQLDMOJobExecution_Unknown | 0 | State cannot be determined. |
| SQLDMOJobExecution_WaitingForStepToFinish | 6 | Job is waiting on the outcome of a step. |
| SQLDMOJobExecution_WaitingForWorkerThread | 2 | Job is blocked, unable to obtain a thread resource. |