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.
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 Distributed Management Objects (SQL-DMO) through the CountResetDate, LastOccurrenceDate, and OccurrenceCount properties of the Alert object.
Applies To:
See Also
Reference
CountResetDate Property
OccurrenceCount Property
LastOccurrenceDate Property