Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Lynn Armbruster: "Thank you. I found Maestro easy to use and so far a great tool".
DavidNR: "MS SQL Maestro is a great app. Loved it. I only used it for its blob support thus far, very nice and very fast".

More

Add your opinion

MS SQL Maestro online Help

Prev Return to chapter overview Next

Editing alert properties

Use the following information to clear up all the alert properties.
 

Operator notifications

The grid represents all the available server operators. Check necessary box to assign operator the alert to give notice of and the type of notification.

 

Properties

Name

Here you can edit the name of the alert.

 

Category

Defines the name of the alert category. See Categories for details.

 

Type

Describes the type of the alert. 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

Shows 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 database is not 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.

 

Last Occurred

Shows the last date when the alert has been occurred.

 

Last Responded

Displays the date when the alert has last raised response.

 

Occurrence count

Displays the amount of alert occurrences.

 

Notifications

This tab displays all server operators as a grid. Select the necessary notification, then press Enter or select the Edit... item from the popup menu or open Operator Editor. Use grid's popup menu to edit, copy the selected operators.

 

You can manage several operators at a time. For this you have to select operators with the Shift or the Ctrl key pressed. After the objects group is selected, you can operate on it as if it were a single object. Using the checkboxes you can specify the method by which the operator is notified (E-mail, Pager or/and Net send) when the alert occurs.

 

To apply the changes, select the Apply Changes item in the Navigation bar or use Ctrl+F9 or Ctrl+F7 shortcut keys.

 

It is also possible to modify object properties without opening the object editor: use the Object Properties item of the popup menu of the selected object from the explorer tree.



Prev Return to chapter overview Next