How to define the response to an alert (Enterprise Manager)

How to Install SQL Server 2000

How To

How to define the response to an alert (Enterprise Manager)

To define the response to an alert

  1. Expand a server group, and then expand a server.

  2. Expand Management, and then expand SQL Server Agent.

  3. Click Alerts, and in the details pane, right-click an alert.

  4. Click Properties, and then click the Response tab.

  5. Select the Execute job check box, and then click a job to execute when the alert occurs.

    You can create a new job by clicking (New Job), or modify an existing job by clicking the browse (...) button.

  6. Under Operators to notify, select one or more of the following check boxes for one or more operators: E-mail, Pager, or Net send.

    Be sure that each operator's notification method is valid.

  7. Select the appropriate Include alert error text in check box for the notification method used if you want the alert error text to be sent with the notification.

  8. Under Additional notification message to send to operator, enter additional information for the operator.

    The maximum number of characters is 512.

See Also

How to assign alerts to an operator (Enterprise Manager)

How to create an operator (Enterprise Manager)

How to modify a job (Enterprise Manager)