.png)
CurrentRunStatus Property
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.
The CurrentRunStatus property returns the executing state of a SQL Server Agent job.
The CurrentRunStatus value is interpreted using these values.
| Constant | Value | Description |
|---|---|---|
|
SQLDMOJobExecution_/BetweenRetries |
3 |
The job is waiting on a job step retry attempt. |
|
SQLDMOJobExecution_Executing |
1 |
The job is executing. |
|
SQLDMOJobExecution_Idle |
4 |
The job is idle, awaiting its next scheduled execution. |
|
SQLDMOJobExecution_/PerformingCompletionActions |
7 |
All executable job steps are complete. Job history logging is in progress. |
|
SQLDMOJobExecution_Suspended |
5 |
The job is suspended. |
|
SQLDMOJobExecution_Unknown |
0 |
The state cannot be determined. |
|
SQLDMOJobExecution_/WaitingForStepToFinish |
6 |
The job is waiting on the outcome of a step. |
|
SQLDMOJobExecution_/WaitingForWorkerThread |
2 |
The job is blocked, unable to obtain a thread resource. |
