Compartir a través de


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: