CurrentRunStatus Property

Esta característica se quitará en una versión futura de Microsoft SQL Server. Evite utilizar esta característica en nuevos trabajos de desarrollo y tenga previsto modificar las aplicaciones que actualmente la utilizan.

The CurrentRunStatus property returns the executing state of a SQL Server Agent job.

Sintaxis

object
.CurrentRunStatus

Parts

• object
  An expression that evaluates to an object in the Applies To list.

Data Type

Long, enumerated

Modifiable

Read-only

Prototype (C/C++)

HRESULT GetCurrentRunStatus(
SQLDMO_JOBEXECUTION_STATUS* pRetVal);

Returns

The CurrentRunStatus value is interpreted using these values.

Constant	Value	Description
SQLDMOJobExecution_/BetweenRetries	3	The job is waiting on a job step retry attempt.
SQLDMOJobExecution_Executing	1	The job is executing.
SQLDMOJobExecution_Idle	4	The job is idle, awaiting its next scheduled execution.
SQLDMOJobExecution_/PerformingCompletionActions	7	All executable job steps are complete. Job history logging is in progress.
SQLDMOJobExecution_Suspended	5	The job is suspended.
SQLDMOJobExecution_Unknown	0	The state cannot be determined.
SQLDMOJobExecution_/WaitingForStepToFinish	6	The job is waiting on the outcome of a step.
SQLDMOJobExecution_/WaitingForWorkerThread	2	The job is blocked, unable to obtain a thread resource.

Applies To:

Job Object