Alert.CountResetDate Property
Gets or sets the date on which to reset the alert occurrence count back to zero.
Namespace: Microsoft.SqlServer.Management.Smo.Agent
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public ReadOnly Property CountResetDate As DateTime
Get
'Usage
Dim instance As Alert
Dim value As DateTime
value = instance.CountResetDate
[SfcPropertyAttribute(SfcPropertyFlags.Standalone)]
public DateTime CountResetDate { get; }
[SfcPropertyAttribute(SfcPropertyFlags::Standalone)]
public:
property DateTime CountResetDate {
DateTime get ();
}
[<SfcPropertyAttribute(SfcPropertyFlags.Standalone)>]
member CountResetDate : DateTime
function get CountResetDate () : DateTime
Property Value
Type: System.DateTime
A DateTime object value that specifies the date on which to set the event occurrence count back to zero.
Remarks
The SQL Server Agent alert occurrence count represents the number of times the alert has fired after a specific date and time. The CountResetDate property is used to specify a date and time. Use the ResetOccurrenceCount method to set the occurrence count to 0 and set the CountResetDate property to the current date and time.
Examples
Scheduling Automatic Administrative Tasks in SQL Server Agent
See Also
Reference
Microsoft.SqlServer.Management.Smo.Agent Namespace