Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
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

© 2015 Microsoft