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.
Syntax
object
.CurrentRunStatus
Parts
- object
An expression that evaluates to an object in the Applies To list.
Data Type
Long, enumerated
Modifiable
Read-only
Prototype (C/C++)
HRESULT GetCurrentRunStatus(
SQLDMO_JOBEXECUTION_STATUS* pRetVal);
Returns
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. |