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

Subscribe to our news:
Partners
Testimonials
Kevin Settler: "If you need the job done right and on time, do it with MS SQL Maestro on your team. The software is a pleasure for us. SQL Maestro Group do excellent work and are dedicated to producing products that all can be proud of".
Alex Torin: "Several months ago I downloaded the trial versions of several Microsoft SQL administration tools that I was able to find using google. I had considerable trouble with most of them crashing... but using your product I was able to isolate and solve the problems I was having. I decided to add it to my toolkit and have recommended it to a few others".

More

Add your opinion

MS 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