Job Execution Status Constants (SQLDMO_JOBEXECUTION_STATUS)

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

Job execution status constants define the running state for a SQL Server Agent job.

Constant	Value	Description
SQLDMOJobExecution_/BetweenRetries	3	The job is waiting on a job step retry attempt.
SQLDMOJobExecution_Executing	1	The job is running.
SQLDMOJobExecution_Idle	4	The 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	The job is suspended.
SQLDMOJobExecution_Unknown	0	The state of the job cannot be determined.
SQLDMOJobExecution_/WaitingForStepToFinish	6	The job is waiting for the outcome of a step.
SQLDMOJobExecution_/WaitingForWorkerThread	2	The job is blocked, unable to obtain a thread resource.