The LastRunOutcome property returns the execution completion status of the job or job step for the most recent execution attempt.
| Job Object | JobStep Object |
object.LastRunOutcome
| Part | Description |
|---|---|
| object | Expression that evaluates to an object in the Applies To list |
Interpret the LastRunOutcome property using these values.
| Constant | Value | Description |
|---|---|---|
| SQLDMOJobOutcome_Cancelled | 3 | Execution canceled by user action |
| SQLDMOJobOutcome_Failed | 0 | Execution failed |
| SQLDMOJobOutcome_InProgress | 4 | Job or job step is executing |
| SQLDMOJobOutcome_Succeeded | 1 | Execution succeeded |
| SQLDMOJobOutcome_Unknown | 5 | Unable to determine execution state |
Long, enumerated
Read-only
HRESULT GetLastRunOutcome(SQLDMO_COMPLETION_TYPE* pRetVal);