通过

Alert.LastOccurrenceDate 属性

  • 项目

Gets or sets the date on which the alert was last raised.

命名空间：  Microsoft.SqlServer.Management.Smo.Agent
程序集：  Microsoft.SqlServer.Smo（在 Microsoft.SqlServer.Smo.dll 中）

语法

声明
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public Property LastOccurrenceDate As DateTime 
    Get 
    Set
用法
Dim instance As Alert 
Dim value As DateTime 

value = instance.LastOccurrenceDate

instance.LastOccurrenceDate = value

[SfcPropertyAttribute(SfcPropertyFlags.Standalone)]
public DateTime LastOccurrenceDate { get; set; }

[SfcPropertyAttribute(SfcPropertyFlags::Standalone)]
public:
property DateTime LastOccurrenceDate {
    DateTime get ();
    void set (DateTime value);
}

[<SfcPropertyAttribute(SfcPropertyFlags.Standalone)>]
member LastOccurrenceDate : DateTime with get, set

function get LastOccurrenceDate () : DateTime 
function set LastOccurrenceDate (value : DateTime)

属性值

类型：System.DateTime
A DateTime system object value that specifies the date and time that the alert was last raised.

注释

SQL Server Agent maintains historical data for alerts raised and handled by SQL Server Agent. The date of last occurrence is one piece of historical information maintained.

示例

在 SQL Server 代理中计划自动管理任务

请参阅

参考

Alert 类

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

其他资源

自动执行管理任务（SQL Server 代理）

sp_add_alert (Transact-SQL)