共用方式為


Alert.CountResetDate 屬性

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

命名空間:  Microsoft.SqlServer.Management.Smo.Agent
組件:  Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)

語法

'宣告
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public ReadOnly Property CountResetDate As DateTime 
    Get
'用途
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

屬性值

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

備註

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.

範例

使用 SQL Server Agent 排程自動管理工作

請參閱

參考

Alert 類別

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

其他資源

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

sp_add_alert (Transact-SQL)