Managing Operators

Operators are special accounts that can be notified when alerts are triggered and when scheduled jobs fail, succeed, or complete. Before operators become available, you need to register them. After you register operators, you can enable or disable them for notifications.

Registering Operators

You register operators by completing the following steps:

  1. In SQL Server Management Studio, access the Management folder on the server running SQL Server Agent.

  2. Expand the SQL Server Agent folder.

  3. Right-click the Operators entry in the left pane, and then choose New Operator to display the New Operator dialog box shown in Figure 15-6.

    New Operator dialog box

    Figure 15-6. New ...

Get Microsoft® SQL Server™ 2005 Administrator's Pocket Consultant now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial