.png)
Alert Properties
SQL Server 2008
The Alert type exposes the following members.
| Name | Description | |
|---|---|---|
|
AlertType | Gets the AlertType object value that specifies the type of alert. |
|
|
CategoryName | Gets or sets the name of the category to which the alert belongs. |
|
|
CountResetDate | Gets or sets the date on which to reset the alert occurrence count back to zero. |
|
|
DatabaseName | Gets or sets the name of the database that the alert is monitoring. |
|
|
DelayBetweenResponses | Gets or sets the delay between responses in seconds. |
|
|
EventDescriptionKeyword | Gets or sets a word or phrase that must appear in the text of an event message that causes the alert to be raised. |
|
|
EventSource | Gets the event source text from the application event log. |
|
|
ExecuteForScalar | Gets or sets the Boolean property value that specifies whether the object is set to the execute for scalar option. (Inherited from SqlSmoObject.) |
|
|
HasNotification | Gets the number of SQL Server Agent operators that are assigned to receive notification when the alert is fired. |
|
|
ID | Gets the ID value that uniquely identifies SQL Server Agent. |
|
|
IncludeEventDescription | Gets or sets the NotifyMethods object value that specifies the types of notification methods (e-mail, pager, or net send) that can contain alert error text. |
|
|
IsEnabled | Gets or sets the Boolean property value that specifies whether the alert is enabled or not. |
|
|
IsTouched | Gets the Boolean property value that specifies whether the object properties have been updated but not yet persisted on the server. (Inherited from SqlSmoObject.) |
|
|
JobID | Gets or sets the ID value of the SQL Server Agent job that is run in response to the alert being raised. |
|
|
JobName | Gets or sets the name of the SQL Server Agent job that is run in response to the alert being raised. |
|
|
LastOccurrenceDate | Gets or sets the date on which the alert was last raised. |
|
|
LastResponseDate | Gets or sets the date on which the alert last generated a response. |
|
|
MessageID | Gets or sets the ID value of the Microsoft SQL Server message that causes the alert to be raised. |
|
|
Name | Gets or sets the name of the object. (Inherited from NamedSmoObject.) |
|
|
NotificationMessage | Gets or sets the user-supplied text appended to any notification sent in response to an alert being raised. |
|
|
ObjectInSpace | Gets the Boolean property value that specifies whether the object exists in isolation, or whether it is directly or indirectly connected to the instance of SQL Server. (Inherited from SqlSmoObject.) |
|
|
OccurrenceCount | Gets the number of times the alert has fired since the alert was enabled or since a specified date. |
|
|
Parent | Gets or sets the JobServer object that is the parent of the Alert object. |
|
|
PerformanceCondition | Gets or sets the performance condition text. |
|
|
Properties | Gets a collection of Property objects that represent the object properties. (Inherited from SqlSmoObject.) |
|
|
ScalarResult | Gets the scalar result for the referenced object. (Inherited from SqlSmoObject.) |
|
|
Severity | Gets or sets the error message severity level that causes the alert to be raised. |
|
|
State | Gets the state of the referenced object. (Inherited from SmoObjectBase.) |
|
|
Urn | Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. (Inherited from SqlSmoObject.) |
|
|
UserData | Gets or sets user-defined data associated with the referenced object. (Inherited from SmoObjectBase.) |
|
|
WmiEventNamespace | Gets or sets the Windows Management Instrumentation (WMI) namespace for the event. |
|
|
WmiEventQuery | Gets or sets the Windows Management Instrumentation (WMI) query for the event. |
