Partners
Download
BuyMS SQL Maestro online Help
| Prev | Return to chapter overview | Next |
Specifying alert options
Specify alert options according to your needs.
Category
Define here the name of the alert category. See Categories for details.
Type
Describe the type of the alert in this field. Possible variants are: SQL Server event alert and SQL server performance condition alert.
Definition Type
This field is available when the SQL Server event alert type is selected. Indicates the definition type of SQL Server event alert.
Error Number
This field is available when the Error Number definition type is selected. Shows the message error number that defines the alert.
Message Template
The field displays the explanation of the error with placeholders for parameters.
Severity
This field is available when the Severity definition type is selected. Defines the severity level (from 1 through 25) that defines the alert.
Database Name
The database in which the error must occur for the alert to fire. If no database is supplied, the alert fires regardless of where the error occurred.
Event Keyword
The sequence of characters that the description of the SQL Server error must be like. Transact-SQL LIKE expression pattern-matching characters can be used. the maximum size of this field is 100. This parameter is useful for filtering object names (for example, %customer_table%).
Object
This field is available when the SQL Server performance condition alert type is selected. A performance object used in performance condition.
Counter
This field is available when the SQL Server performance condition alert type is selected. A performance counter used in performance condition.
Instance
This field is available when the SQL Server performance condition alert type is selected. A named instance of the counter used in performance condition.
Condition
This field is available when the SQL Server performance condition alert type is selected. Defines comparator in performance condition.
Value
This field is available when the SQL Server performance condition alert type is selected. Numeric value of the counter.
Enabled
Indicates the current status of the alert. If unchecked, the alert is not enabled and does not fire.
Job
The name of the job to be executed in response to this alert.
Include Alert Error In
The description of the SQL Server error should be included as part of the notification message. Can have one or more of values (None, E-mail, Pager, Net send) combined with an OR logical operator.
Notification Message
Is an optional additional message sent to the operator as part of the e-mail, net send, or pager notification.
Minutes
The delay period, in minutes, between responses to the alert.
Seconds
The delay period, in seconds, between responses to the alert.
| Prev | Return to chapter overview | Next |
