OccurrenceCount Property
В будущей версии Microsoft SQL Server эта возможность будет удалена. Избегайте использования этой возможности в новых разработках и запланируйте изменение существующих приложений, в которых она применяется.
The SQL Server Agent alert occurrence count represents the number of times the alert has fired after a specific date and time.
Синтаксис
object
.OccurrenceCount [= value]
Parts
object
An expression that evaluates to an object in the Applies To listvalue
A 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);
Замечания
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.