OccurrenceCount Property

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 SQL Server Agent alert occurrence count represents the number of times the alert has fired after a specific date and time.

Syntax

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

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.

Applies To:

Alert Object

 

See Also

Reference

CountResetDate Property
ResetOccurrenceCount Method

Help and Information

Getting SQL Server 2005 Assistance