ResetOccurrenceCount Method

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

The ResetOccurrenceCount method reinitializes history data for a SQL Server Agent alert.




  • object
    Expression that evaluates to an object in the Applies To list.

Prototype (C/C++)

HRESULT ResetOccurrenceCount();


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 Distributed Management Objects (SQL-DMO) through the CountResetDate, LastOccurrenceDate, and OccurrenceCount properties of the Alert object.

Applies To: