Partager via

  • Article

OccurrenceCount Property

Cette fonctionnalité sera supprimée dans une prochaine version de Microsoft SQL Server. Évitez d'utiliser cette fonctionnalité dans de nouveaux travaux de développement et prévoyez de modifier les applications qui utilisent actuellement cette fonctionnalité.

The SQL Server Agent alert occurrence count represents the number of times the alert has fired after a specific date and time.

Syntaxe

object.OccurrenceCount [= value]

Parts

  • object
    An expression that evaluates to an object in the Applies To list

  • value
    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);

Notes

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.

Applies To:

Alert Object