Alert Properties

 

Namespace:   Microsoft.SqlServer.Management.Smo.Agent
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

NameDescription
System_CAPS_pubpropertyAlertType

Gets the AlertType object value that specifies the type of alert.

System_CAPS_pubpropertyCategoryName

Gets or sets the name of the category to which the alert belongs.

System_CAPS_pubpropertyCountResetDate

Gets or sets the date on which to reset the alert occurrence count back to zero.

System_CAPS_pubpropertyDatabaseName

Gets or sets the name of the database that the alert is monitoring.

System_CAPS_pubpropertyDelayBetweenResponses

Gets or sets the delay between responses in seconds.

System_CAPS_pubpropertyEventDescriptionKeyword

Gets or sets a word or phrase that must appear in the text of an event message that causes the alert to be raised.

System_CAPS_pubpropertyEventSource

Gets the event source text from the application event log.

System_CAPS_pubpropertyExecutionManager

Gets the object to execute to the manager.(Inherited from SqlSmoObject.)

System_CAPS_pubpropertyHasNotification

Gets the number of SQL Server Agent operators that are assigned to receive notification when the alert is fired.

System_CAPS_pubpropertyID

Gets the ID value that uniquely identifies SQL Server Agent.

System_CAPS_pubpropertyIncludeEventDescription

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.

System_CAPS_pubpropertyIsEnabled

Gets or sets the Boolean property value that specifies whether the alert is enabled or not.

System_CAPS_pubpropertyJobID

Gets or sets the ID value of the SQL Server Agent job that is run in response to the alert being raised.

System_CAPS_pubpropertyJobName

Gets or sets the name of the SQL Server Agent job that is run in response to the alert being raised.

System_CAPS_pubpropertyLastOccurrenceDate

Gets or sets the date on which the alert was last raised.

System_CAPS_pubpropertyLastResponseDate

Gets or sets the date on which the alert last generated a response.

System_CAPS_pubpropertyMessageID

Gets or sets the ID value of the Microsoft SQL Server message that causes the alert to be raised.

System_CAPS_pubpropertyName

Gets or sets the name of the object.(Inherited from NamedSmoObject.)

System_CAPS_pubpropertyNotificationMessage

Gets or sets the user-supplied text appended to any notification sent in response to an alert being raised.

System_CAPS_pubpropertyOccurrenceCount

Gets the number of times the alert has fired since the alert was enabled or since a specified date.

System_CAPS_pubpropertyParent

Gets or sets the JobServer object that is the parent of the Alert object.

System_CAPS_pubpropertyPerformanceCondition

Gets or sets the performance condition text.

System_CAPS_pubpropertyProperties

Gets a collection of Property objects that represent the object properties.(Inherited from SqlSmoObject.)

System_CAPS_pubpropertySeverity

Gets or sets the error message severity level that causes the alert to be raised.

System_CAPS_pubpropertyState

Gets the state of the referenced object.(Inherited from SmoObjectBase.)

System_CAPS_pubpropertyUrn

Gets the Uniform Resource Name (URN) address value that uniquely identifies the object.(Inherited from SqlSmoObject.)

System_CAPS_pubpropertyUserData

Gets or sets user-defined data associated with the referenced object.(Inherited from SmoObjectBase.)

System_CAPS_pubpropertyWmiEventNamespace

Gets or sets the Windows Management Instrumentation (WMI) namespace for the event.

System_CAPS_pubpropertyWmiEventQuery

Gets or sets the Windows Management Instrumentation (WMI) query for the event.

Return to top
Show: