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

To script alerts using Transact-SQL

1. Right-click Alerts; then click All Tasks/Script All Alerts.
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 alert if it exists to include in the script commands to delete any alerts 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.
   • Include the name of the job executed by the alert to include in the script commands to provide the name of the job executed by the alert.
5. Enter a T-SQL batch separator. Include the name of the job executed by the alert to have the alerts generated by the script reference their response jobs. The default is GO.