Alert.LastOccurrenceDate Property

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

Namespace:  Microsoft.SqlServer.Management.Smo.Agent
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public Property LastOccurrenceDate As DateTime 
    Get 
    Set
'Usage
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)

Property Value

Type: System.DateTime
A DateTime system object value that specifies the date and time that the alert was last raised.

Remarks

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.

Examples

Scheduling Automatic Administrative Tasks in SQL Server Agent

See Also

Reference

Alert Class

Microsoft.SqlServer.Management.Smo.Agent Namespace

Other Resources

Automated Administration Tasks (SQL Server Agent)

sp_add_alert (Transact-SQL)