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)

public enum JobExecutionStatus

Member nameDescription
ExecutingValue = 1. The job is being run.
WaitingForWorkerThreadValue = 2. The job is waiting for a worker thread.
BetweenRetriesValue = 3. The job is waiting to retry after a failure.
IdleValue = 4. The job is idle.
SuspendedValue = 5. The job is suspended.
WaitingForStepToFinishValue = 6. The job is waiting for another branch of logic to finish before it can continue.
PerformingCompletionActionValue = 7. The job is in the final completion stage.

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

Community Additions