When you Add a new alert, a new window opens where you can specify the following general settings:
- Name - type a name that identifies your alert.
- Enabled - select this option to enable the alert you are creating; otherwise, the alert will not be generated.
- Type - choose from these alert types:
- SQL Server event alert - generates an alert that responds to messages in the Microsoft Windows event log.
- SQL Server performance condition alert - generates an alert that responds to a specific condition in a performance counter.
- WMI event alert - generates an alert that responds to a Windows Management Instrumentation (WMI) event.
According to the type of alert type you choose, SQL Enterprise Job Manager displays different options.
Available options when you select SQL Server event alert type
If you choose a SQL Server event alert type, on the Event alert definition settings you can define:
- Database name - identify the database that generates the event. Alternatively, you can choose All Databases if you want the alert to respond to a specific message regardless of the database where the event occurs.
- Alert will be raised based on - define when alerts will be raised, you can select from any of these options:
- Error number - you can define an alert to be raised in response to an error number you type in this section.
- Severity - you can define the alert to respond to a message with a specific severity. Use the respective drop-down options to select a message with a specific severity.
- Raise alert when message contains - use this option when you want the alert to respond to the message you type in the respective box.
Options when choosing SQL Server performance condition alert type
If you choose a SQL Server performance condition alert type, on the Performance condition alert definition you can define:
- Object - select the object to monitor from the drop-down options.
- Counter - select the counter to be used with the selected object. The options available on the drop-down options depend on the object selected before.
- Instance - specify the instance where the counter generates the alert. The drop-down options available on display depend on the selected object.
- Alert if counter - choose how alerts are generated in relation to the selected counter. You can select from: falls below, becomes equal to, rises above.
- Value - type the value that raises your alert.
Options when choosing WMI event alert type
If you choose a WMI event alert type, on the WMI event alert definition you can define:
- Namespace - type the namespace path where the WMI query runs.Only namespaces on the computer that runs SQL Server Agent are supported.
- Query - type a custom WQL statement the alert responds to.