Page History

How are Alert Rules helpful to you?

SQL Enterprise Job Manager allows you to create your own specific alert rules based on your requirements for specific jobs, instances, jobs duration, etc. and assign them your preferred severity.

...

SQL Enterprise Job Manager lets you define these alert rules so that you can get notified with the most relevant issues of your environment. 

Adding new Alert Rules

To add a new alert rule, click Add Alert Rule on the top bar menu. SQL Enterprise Job Manager opens a wizard for configuring new alert rules with two tabs: General and Configuration.

What fields are available on the General tab?

The General tab allows you to specify the general settings of your alert rule. You can find the following fields:

• Name - type a name that helps you identify your alert rule
• Enabled - select this option if you want to enable the alert as soon as it is created. You can add alert rules first and enable them later.
• Severity type - choose your desired severity for the alert rule. Choose from CRITICAL, WARNING, INFORMATIONAL, or OK. 
• Alert type - select the type of alert rule you are creating. It could be an alert rule for instances or jobs. 
• Description - type a description that helps you identify the alert rule and describes its main characteristics.

What fields are available on the Configuration tab?

The configuration tab allows you to define the main parameters of your alert rule; in other words, what conditions have to be complied in order to generate an alert.

...

• Property - select those properties you want the alert rule to take into account for generating alerts. You can choose to have alerts according to the Instance name, Status, or Agent Status.  
• Type - for your selected properties, choose if you want to INCLUDE or EXCLUDE a defined value. 
• Value - specify a value for each selected Property. This value determines when your alert rule is generated. For the values take into account:
  • If you choose the Instance property, you can use wildcard characters such as: %, _, [ ], [^]. Avoid using these characters in names or SQL Enterprise Job Manager can take them for wildcard characters. 
  • If you select the Status property, use the drop-down options to select from Unknown, Online, Connection Failure, Unsupported SQL Server Version, Authentication Failure, or Error.
  • If you select the Agent Status property, use the drop-down options to select from Running, Stopped, Stopping, Starting, or Unknown. 

How do you edit alert rules?

You can edit your own created alert rules as well as the established default alert rules (SQL Server instance connection failures, SQL Server Agent not running, and Job Failures).

...