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