SQL-DMO

DateFindOperand Property

The DateFindOperand property directs evaluation of the DateJobCreated and DateJobLastModified properties.

Applies To
JobFilter Object

Syntax

object.DateFindOperand [= value]

Parts

object

Expression that evaluates to an object in the Applies To list

value

Long integer that specifies a comparison operand as described in Settings

Data Type

Long, enumerated

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetDateFindOperand(SQLDMO_FIND_OPERAND* pRetVal);

HRESULT SetDateFindOperand(SQLDMO_FIND_OPERAND NewValue);

Settings
Constant Value Description
SQLDMOFindOperand_EqualTo 1 Default. Return values equal to the user-defined, qualifying value.
SQLDMOFindOperand_GreaterThan 2 Return values greater than the user-defined, qualifying value.
SQLDMOFindOperand_LessThan 3 Return values less than the user-defined, qualifying value.
SQLDMOFindOperand_Unknown 0 Do not apply filtering on comparison against the qualifying value.

Remarks

The EnumJobs method of the JobServer object lists SQLServerAgent jobs. Set the properties of the method's JobFilter part to direct job enumeration.

The DateJobCreated property filters results by creation date. The DateJobLastModified property filters results by modification date. By default, the EnumJobs method evaluates filter properties for equality. Set the DateFindOperand property to direct evaluation of the filter dates, for example, to list jobs created after a given date.