Condividi tramite


DateFindOperand Property

Questa funzionalità verrà rimossa in una delle prossime versioni di Microsoft SQL Server. Evitare di utilizzare questa funzionalità in un nuovo progetto di sviluppo e prevedere interventi di modifica nelle applicazioni in cui è attualmente implementata.

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

Sintassi

object
.DateFindOperand [=value]

Parts

  • object
    An expression that evaluates to an object in the Applies To list.
  • value
    A 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

The default. It returns values equal to the user-defined, qualifying value.

SQLDMOFindOperand_GreaterThan

2

Returns values greater than the user-defined, qualifying value.

SQLDMOFindOperand_LessThan

3

Returns values less than the user-defined, qualifying value.

SQLDMOFindOperand_Unknown

0

Does not apply filtering on comparison against the qualifying value.

Osservazioni

The EnumJobs method of the JobServer object lists SQL Server Agent jobs. Set the properties of the method's JobFilter argument 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.

Applies To:

JobFilter Object