Compartir a través de


Alert.CountResetDate Propiedad

Gets or sets the date on which to reset the alert occurrence count back to zero.

Espacio de nombres:  Microsoft.SqlServer.Management.Smo.Agent
Ensamblado:  Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)

Sintaxis

'Declaración
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public ReadOnly Property CountResetDate As DateTime 
    Get
'Uso
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

Valor de la propiedad

Tipo: System.DateTime
A DateTime object value that specifies the date on which to set the event occurrence count back to zero.

Comentarios

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.

Ejemplos

Programar tareas administrativas automáticas en el Agente SQL Server

Vea también

Referencia

Alert Clase

Espacio de nombres Microsoft.SqlServer.Management.Smo.Agent

Otros recursos

Tareas administrativas automatizadas (Agente SQL Server)

sp_add_alert (Transact-SQL)