Share via


CurrentRunStatus Property

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

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

Syntax

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