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

	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.

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