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

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

To script operators using Transact-SQL

1. Expand a server group, and then expand a server.
   
   
2. Expand Management, and then expand SQL Server Agent.
   
   
3. Right-click Operators, point to All Tasks, and then click Generate SQL Script.
   
   
4. In the File name box, type a name for the script.
   
   
5. Under File format, do one of the following:
   • Click MS-DOS Text (OEM) to save the script in OEM format.
     
     
   • Click Windows Text (ANSI) to save the script in ANSI format.
     
     
   • Click International Text (Unicode) to save the script in Unicode format.
6. Under SQL generation options, do one or both of the following:
   • Select the Replace operator if it exists check box to include in the script commands to that will delete any operators with the same name as jobs generated by the script.
     
     
   • Select the Include notifications sent by alerts to the operator check box to include in the script commands to generate alert assignments for the operators generated by the script.
7. Enter a Transact-SQL batch separator.