The LastRunOutcome property returns the execution completion status of the job or job step for the most recent execution attempt.
object.LastRunOutcome
object
Expression that evaluates to an object in the Applies To list
Long, enumerated
Read-only
HRESULT GetLastRunOutcome(SQLDMO_COMPLETION_TYPE* pRetVal);
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. |