How to: Create an Operator (SQL Server Management Studio)

This topic describes how to configure a user to receive notifications about Microsoft SQL Server Agent jobs.

To create an operator

  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. Right-click Operators and then click New Operator.

  4. In the New Operator dialog box, type the Name of the operator.

  5. To define notification methods for the operator, do one or more of the following:

    • In the E-mail name box, enter the operator's e-mail address if the operator will be notified by e-mail.

    • In the Net send address box, enter the operator's net send address if the operator will be notified by net send.

    • In the Pager e-mail name box, enter the pager address of the operator's pager service if the operator will be notified by pager. Also check the days and select the hours when the operator is available to receive pager notifications.

    Important

    The Pager and net send options will be removed from SQL Server Agent in a future version of Microsoft SQL Server. Avoid using these features in new development work, and plan to modify applications that currently use these features.

    Note that SQL Server Agent must be configured to use Database Mail or SQL Mail to send e-mail and pager notifications to operators. For more information, see How to: Set the Mail Profile for SQL Server Agent (SQL Server Management Studio).