OutcomeTypes Property (SQL-DMO)

The OutcomeTypes property controls job history filtering by completion status of a job.

Applies To

JobHistoryFilter Object

Syntax

object.OutcomeTypes [= value]

Part Description
object Expression that evaluates to an object in the Applies To list
value Long integer specifying a job completion status as described in Settings

Settings
Constant Value Description
SQLDMOJobOutcome_Cancelled 3 Filter for jobs terminated at user direction.
SQLDMOJobOutcome_Failed 0 Filter for jobs that failed completion.
SQLDMOJobOutcome_InProgress 4 Filter for jobs currently running.
SQLDMOJobOutcome_Succeeded 1 Filter for successfully completed jobs.
SQLDMOJobOutcome_Unknown 5 Ignore any completion status. Do not use completion status as a filter criteria.

Data Type

Long, enumerated

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetOutcomeTypes(
SQLDMO_JOBOUTCOME_TYPE* pRetVal);

HRESULT SetOutcomeTypes(
SQLDMO_JOBOUTCOME_TYPE NewValue);

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.