ResetOccurrenceCount Method

SQL-DMO

SQL-DMO

ResetOccurrenceCount Method

The ResetOccurrenceCount method reinitializes history data for a SQLServerAgent alert.

Applies To
Alert Object
Syntax

object.ResetOccurrenceCount( )

Parts

object

Expression that evaluates to an object in the Applies To list

Prototype (C/C++)

HRESULT ResetOccurrenceCount();

Remarks

The ResetOccurrenceCount method:

  • Sets to zero the counter representing the number of times an alert has been raised.

  • Sets the date and time marking the start of counting to the current date and time.

Alert history values are visible in SQL-DMO through the CountResetDate, LastOccurrenceDate, and OccurrenceCount properties of the Alert object.

See Also

CountResetDate Property

OccurrenceCount Property

LastOccurrenceDate Property