Online Documentation for SQL Administrator for SQL Server

Setting response

The Response tab allows you to specify actions that the SQL Server Agent service will take after the alert fires.

Job name

Use the drop-down list to select the name of the job to be executed in response to this alert. You can also create a new job by clicking the Add button. To clear the field use the button.

Notify operators when alert is raised

Alert notifications ensure that database administrators know when events/errors occur and which measures are taken in response. The main area lists all currently available operators. Specify the method by which an operator is to be notified: E-mail, Pager, Net Send. Set the corresponding flag next to the operator name.

Note: You can add an operator by right-clicking the area and selecting New operator... item.