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)