Alert.OccurrenceCount Property
Gets the number of times the alert has fired since the alert was enabled or since a specified date.
Namespace: Microsoft.SqlServer.Management.Smo.Agent
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public ReadOnly Property OccurrenceCount As Integer
Get
'Usage
Dim instance As Alert
Dim value As Integer
value = instance.OccurrenceCount
[SfcPropertyAttribute(SfcPropertyFlags.Standalone)]
public int OccurrenceCount { get; }
[SfcPropertyAttribute(SfcPropertyFlags::Standalone)]
public:
property int OccurrenceCount {
int get ();
}
[<SfcPropertyAttribute(SfcPropertyFlags.Standalone)>]
member OccurrenceCount : int
function get OccurrenceCount () : int
Property Value
Type: System.Int32
An Int32 value that specifies the number of times an alert has fired since the alert was enabled or since a specified date.
Remarks
The CountResetDate property marks the date and time to start counting for a SQL Server Agent alert occurrence count. Use the ResetOccurrenceCount method to set the alert occurrence count to zero.
Examples
Scheduling Automatic Administrative Tasks in SQL Server Agent
See Also
Reference
Microsoft.SqlServer.Management.Smo.Agent Namespace