How to: Assign Alerts to an Operator (SQL Server Management Studio)

This topic describes how to assign Microsoft SQL Server Agent alerts to operators so they can receive notifications about jobs.

  1. In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.

  2. Expand SQL Server Agent.

  3. Expand Operators.

  4. Right-click an operator, select Properties, and select the Notifications page.

  5. Under View notifications sent to this user by, select Alerts to view a list of alerts sent to this operator or select Jobs to view a list of jobs that send notifications to this operator. Select one or more of the following checkboxes to define the notification method for each notification as necessary: E-mail, Pager, or Net send.

Community Additions