Delen via


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
Executing Value = 1. The job is being run.
WaitingForWorkerThread Value = 2. The job is waiting for a worker thread.
BetweenRetries Value = 3. The job is waiting to retry after a failure.
Idle Value = 4. The job is idle.
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.
PerformingCompletionAction Value = 7. The job is in the final completion stage.

Remarks

The JobExecutionStatus enumeration class is served by the CurrentRunStatus property and EnumJobs method.