Alert Properties

Alert Object Properties Methods Lists Collections

Property Description

Application
    Application
    Write: No
The Application object.
CountResetDate
    Date
    Write: Yes
The date and time the OccuranceCount property was last set to zero.
DatabaseName
    Identifier
    Write: Yes
The database for this alert. If specified, this alert will fire only for events in this database.
DelayBetweenResponses
    Long
    Write: Yes
The delay in seconds between the previous response and the next response for a recurring alert. Set this property to limit the number of responses for the same event.
Enabled
    
Boolean
    Write: Yes
Determines if the alert is active. If True, this alert is active and can be fired by SQL Executive. If False, this alert is disabled and will not fire.
EventCategory
    String
    Write: No
Reserved. Do not change this property.
EventDescriptionKeyword
    String
    Write: Yes
A string to do a case-insensitive search for in the event description. If specified, this alert will fire only for events which have a description that contains this string.
EventID
    String
    Write: No
Reserved. Do not change this property.
EventSource
    String
    Write: No
Reserved. Do not change this property. (Currently "MSSQLServer").
HasEmailNotification
    Long
    Write: No
The number of operators that receive e-mail notification when this alert fires.
HasPagerNotification
    Long
    Write: No
The number of operators that receive pager notification when this alert fires.
ID
    Long
    Write: No
The alert ID.
IncludeEventDescription
    NotifyType
    Write: Yes
The notification types in which to include the event description.
LastOccuranceDate
    Date
    Write: Yes
The date and time when this alert was last fired.
LastResponseDate
    Date
    Write: Yes
The date and time when a response last occurred for this alert. This is affected by the DelayBetweenResponses property.
MessageID
    Long
    Write: Yes
The SQL Server message number that will fire this alert. If you specify the MessageID property you cannot specify the Severity property.
Name
    String
    Write: Yes
The alert name. It must be unique.
NotificationMessage
    String
    Write: Yes
The custom text (maximum of 255 characters) to send along with the response when this alert is fired.
OccuranceCount
    Long
    Write: Yes
The number of times this alert has been fired since the date and time specified by the CountResetDate property. To clear this count, set this property to zero.
Parent
    SQLServer
    Write: No
The SQLServer object.
Severity
    Long
    Write: Yes
The SQL Server message severity that will fire this event. If you specify the Severity property you cannot specify the MessageID property.
TaskName
    String
    Write: Yes
The task to execute when this alert is fired.
TypeOf
    SQLOLE_OBJECT_TYPE
    Write: No
The type of object.
UserData
    Long
    Write: Yes
Temporary storage space contained in this object for private use by the application. SQL-DMO does not use this property.