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. |