Поделиться через


CurrentRunStatus Property

В будущей версии Microsoft SQL Server эта возможность будет удалена. Избегайте использования этой возможности в новых разработках и запланируйте изменение существующих приложений, в которых она применяется.

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

Синтаксис

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: