Alert.OccurrenceCount 속성

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

네임스페이스:  Microsoft.SqlServer.Management.Smo.Agent
어셈블리:  Microsoft.SqlServer.Smo(Microsoft.SqlServer.Smo.dll)

구문

‘선언
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public ReadOnly Property OccurrenceCount As Integer 
    Get
‘사용 방법
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

속성 값

유형: 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.

주의

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.

SQL Server 에이전트에서 자동 관리 태스크 예약

참고 항목

참조

Alert 클래스

Microsoft.SqlServer.Management.Smo.Agent 네임스페이스

관련 자료

관리 태스크 자동화(SQL Server 에이전트)

sp_add_alert(Transact-SQL)