OccurrenceCount Property
Esta característica se quitará en una versión futura de Microsoft SQL Server. Evite utilizar esta característica en nuevos trabajos de desarrollo y tenga previsto modificar las aplicaciones que actualmente la utilizan.
The SQL Server Agent alert occurrence count represents the number of times the alert has fired after a specific date and time.
Sintaxis
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);
Comentarios
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.