CurrentRunStatus Property
Dieses Feature wird in einer zukünftigen Version von Microsoft SQL Server entfernt. Verwenden Sie dieses Feature beim Entwickeln neuer Anwendungen nicht, und planen Sie das Ändern von Anwendungen, in denen es zurzeit verwendet wird.
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. |