SQL-DMO
OutcomeTypes Property
The OutcomeTypes property controls job history filtering by completion status of a job.
Applies To
| JobHistoryFilter Object |
Syntax
object.OutcomeTypes [= value]
Parts
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
Data Type
Long, enumerated
Modifiable
Read/write
Prototype (C/C++)
HRESULT GetOutcomeTypes(
SQLDMO_JOBOUTCOME_TYPE* pRetVal);
HRESULT SetOutcomeTypes(
SQLDMO_JOBOUTCOME_TYPE NewValue);
Settings
| 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. |