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.
Before using SQL Server operators, make sure that the SQL Server Agent service is running.
To create a new operator:
- right-click the Operators node (within the Server Objects branch) or any object within this node in the DB Explorer tree and select the New Operator item from the context menu;
- define operator properties using the appropriate tabs of Operator Editor.
- select the Database | New Object... main menu item;
- select Operator in the Create New Object dialog;
- define operator properties using Operator Editor.
Hint: To create a new operator, you can also select the Services | SQL Server Agent | Operators main menu item to open the Operators manager and select the Add Operator... item from the context menu or on the Navigation bar.
To create a new operator with the same properties as one of existing operators has:
- select the Database | Duplicate Object... menu item;
- follow the instructions of Duplicate Object Wizard.
Alternatively, you can right-click an operator in the DB Explorer tree and select the Duplicate Operator <operator_name>... context menu item.
Duplicate Object Wizard allows you to select the server to create a new operator and to edit the result SQL statement for creating the operator.
To edit an existing operator:
- select the operator for editing in the DB Explorer tree (type the first letters of the operator name for quick search);
- right-click the object and select the Edit Operator <operator_name> context menu item, or simply double-click the operator;
- edit operator properties using the appropriate tabs of Operator Editor.
To change the name of an operator:
- select the operator to rename in the DB Explorer tree;
- right-click the operator alias and select the Rename Operator <operator_name>... item from the context menu;
- edit the operator name using the Rename Object... dialog.
To drop an operator:
- select the operator to drop in the DB Explorer tree;
- right-click the object and select the Drop Operator <operator_name>... context menu item;
- confirm dropping in the dialog window.
Note: If more convenient, you can also use the following shortcuts:
Ctrl+N to create a new operator;
Ctrl+O to edit the selected operator;
Ctrl+R to rename the operator;
Shift+Del to drop the object.
To create, edit, rename and drop operators, you can also use the context menu and the Navigation bar of Operators manager.