SQL-DMO
OccurrenceCount Property
The SQL Server Agent alert occurrence count represents the number of times the alert has fired after a specific date and time.
Applies To
Alert Object |
Syntax
object.OccurrenceCount [= value]
Parts
object
Expression that evaluates to an object in the Applies To list
value
Long integer that specifies the number of times a SQL Server Agent alert has been raised after the reset date for the alert
Data Type
Long
Modifiable
Read-only
Prototype (C/C++)
HRESULT GetOccurrenceCount(LPLONG pRetVal);
Remarks
The CountResetDate property marks date and time for the beginning of counting for a SQL Server Agent alert occurrence count. Use the ResetOccurrenceCount method to set the alert occurrence count to zero.