Page History
...
- 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.
...
- Object - select the object to monitor from the drop-down options 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.
...
- 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.
SQL Enterprise Job Manager monitors and manages your SQL Server agent jobs. Learn more > >
...
...