How to script operators using Transact-SQL (Enterprise Manager)

To script operators using Transact-SQL

1. Right-click Operators; then click All Tasks/Script All Operators.
2. In the Generate SQL Script dialog box, in the File name box, enter a name for the script.
3. Under File format, select:
   • MS-DOS text (OEM) to save the script in OEM format.
   • Windows text (ANSI) to save the script in ANSI format.
   • International text (Unicode) to save the script in Unicode format.
4. Under SQL generation options, select:
   • Replace operator if it exists to include in the script commands to delete any operators with the same name as jobs generated by the script.
   • Include notifications sent by alerts to the operator to include in the script commands to generate alert assignments for the operators generated by the script.
5. Enter a T-SQL batch separator. The default is GO.