Alert Members
Include Protected Members
Include Inherited Members
The Alert class represents a Microsoft SQL Server Agent alert.
The Alert type exposes the following members.
Constructors
| Name | Description | |
|---|---|---|
.gif "Public method") |
Alert() | Initializes a new instance of the Alert class. |
|
Alert(JobServer, String) | Initializes a new instance of the Alert class on the specified instance of SQL Server Agent and with the specified name |
Top
Methods
.gif "Protected method")
Top
.gif "Protected field")
Properties
| Name | Description | |
|---|---|---|
.gif "Public property") |
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. |
.gif "Protected property") |
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. |
Top
Events
| Name | Description | |
|---|---|---|
.gif "Public event") |
PropertyChanged | (Inherited from SqlSmoObject.) |
|
PropertyMetadataChanged | (Inherited from SqlSmoObject.) |
Top
Explicit Interface Implementations
| Name | Description | |
|---|---|---|
.gif "Explicit interface implemetation") .gif "Private method") |
IAlienObjectDiscover() | (Inherited from SqlSmoObject.) |
|
IAlienObjectGetParent() | (Inherited from SqlSmoObject.) |
|
IAlienObjectGetProperty(String) | (Inherited from SqlSmoObject.) |
|
ISfcPropertyProviderGetPropertySet() | (Inherited from SqlSmoObject.) |
|
IAlienObjectGetUrn() | (Inherited from SqlSmoObject.) |
|
IAlienObjectResolve(String) | (Inherited from SqlSmoObject.) |
|
IAlienObjectSetProperty(Object, Object) | (Inherited from SqlSmoObject.) |
Top