共用方式為


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: