Freigeben über


CurrentRunStatus Property

Diese Funktion wird in zukünftigen Versionen von Microsoft SQL Server nicht mehr bereitgestellt. Verwenden Sie diese Funktion beim Entwickeln neuer Anwendungen nicht, und planen Sie das Ändern von Anwendungen, in denen es zurzeit verwendet wird.

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: