Job execution status constants define the running state for a 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 its next scheduled execution. |
| SQLDMOJobExecution_ PerformingCompletionActions |
7 | All executable job steps have completed. Job history logging is being performed. |
| SQLDMOJobExecution_Suspended | 5 | Job has been 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. |