共用方式為


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 Agent 排程自動管理工作

請參閱

參考

Alert 類別

Microsoft.SqlServer.Management.Smo.Agent 命名空間

其他資源

自動化管理工作 (SQL Server Agent)

sp_add_alert (Transact-SQL)