Compartir a través de


Alert.OccurrenceCount Propiedad

Gets the number of times the alert has fired since the alert was enabled or since a specified date.

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 OccurrenceCount As Integer 
    Get
'Uso
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

Valor de la propiedad

Tipo: 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.

Comentarios

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.

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)