Partilhar via

  • Artigo

EndRunDate Property

Esse recurso será removido em uma versão futura do Microsoft SQL Server. Evite usar esse recurso em desenvolvimentos novos e planeje modificar os aplicativos que atualmente o utilizam.

The EndRunDate property specifies the most recent execution date of a SQL Server Agent job.

Sintaxe

object.EndRunDate [=value]

Parts

  • object
    An expression that evaluates to an object in the Applies To list

  • value
    A long integer that specifies a date value as described in Remarks

Data Type

Long

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetEndRunDate(LPLONG pRetVal);
HRESULT SetEndRunDate(long NewValue);

Comentários

By default, EndRunDate is 0. If 0, the property is not evaluated as part of job history filtering.

ObservaçãoObservação

When SQL Distributed Management Objects (SQL-DMO) uses a scaled long integer to represent a date, the integer is built as a sum of the year scaled by 10000, the month scaled by 100, and the day. For example, the date April 19, 1997 is represented by the long integer value 19970419.