The OutcomeTypes property controls job history filtering by completion status of a job.
object.OutcomeTypes [= value]
object
Expression that evaluates to an object in the Applies To list
value
Long integer that specifies a job completion status as described in Settings
Long, enumerated
Read/write
HRESULT GetOutcomeTypes(
SQLDMO_JOBOUTCOME_TYPE* pRetVal);
HRESULT SetOutcomeTypes(
SQLDMO_JOBOUTCOME_TYPE NewValue);
| 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. |