Export (0) Print
Expand All
Expand Minimize

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

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

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft