SQL-DMO
LastRunOutcome Property
The LastRunOutcome property returns the execution completion status of the job or job step for the most recent execution attempt.
Applies To
Job Object | JobStep Object |
Syntax
object.LastRunOutcome
Parts
object
Expression that evaluates to an object in the Applies To list
Data Type
Long, enumerated
Modifiable
Read-only
Prototype (C/C++)
HRESULT GetLastRunOutcome(SQLDMO_COMPLETION_TYPE* pRetVal);
Returns
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. |