JobExecutionStatus Enumeration
The JobExecutionStatus enumeration is a list of constant values that specify the execution status of a job or job step.
Namespace: Microsoft.SqlServer.Management.Smo.Agent
Assembly: Microsoft.SqlServer.SqlEnum (in Microsoft.SqlServer.SqlEnum.dll)
Syntax
'Declaration
Public Enumeration JobExecutionStatus
'Usage
Dim instance As JobExecutionStatus
public enum JobExecutionStatus
public enum class JobExecutionStatus
type JobExecutionStatus
public enum JobExecutionStatus
Members
| Member name | Description | |
|---|---|---|
| BetweenRetries | Value = 3. The job is waiting to retry after a failure. | |
| Executing | Value = 1. The job is being run. | |
| Idle | Value = 4. The job is idle. | |
| PerformingCompletionAction | Value = 7. The job is in the final completion stage. | |
| Suspended | Value = 5. The job is suspended. | |
| WaitingForStepToFinish | Value = 6. The job is waiting for another branch of logic to finish before it can continue. | |
| WaitingForWorkerThread | Value = 2. The job is waiting for a worker thread. |
Remarks
The JobExecutionStatus enumeration class is served by the CurrentRunStatus property and EnumJobs method.