Online Documentation for SQL Administrator for SQL Server

Operators


An operator is the object that represents a single SQL Server operator. SQL Server operators receive alert and job status notification in response to events generated by the server. You can assign alert notifications and job notifications for any operator defined for the instance of SQL Server.

 

Note: Before using SQL Server operators, make sure that the SQL Server Agent service is running.

 

Use the object context menu or toolbar buttons to:

Create create a new operator

Edit edit selected operator(s)

Drop drop selected operator(s)

Print create and print the report

  • rename operator
  • enable operator(s)
  • disable operator(s)

 

SQL Server Agent - Operators

 

 

The list displays all existing operators as a grid with the following columns: Name, Enabled, E-mail Address, Pager Address, Net Send Address, Last Notification by E-mail, Last Notification by Pager, Last Notification by Net Send. If more convenient, you can change the order of the columns by dragging their headers horizontally. See the Working with grid section of the SQL Administrator documentation to find out operations that can be performed with the grid.

 

To open an operator in Operator Editor, double-click it in the list of operators. Alternatively, you can right-click the operator alias and select the Edit Operator context menu item.

 

 


See also:

Jobs

Job history

Alerts

Proxies