How to set up or add e-mail, page or net send alerts to LiteSpeed Log Shipping
Modify the Log Shipping job in SQL Server (after its been created by LiteSpeed). Notifications for Log Shipping jobs cannot be set up directly in LiteSpeed.
To set-up the SQL Agent Mail:
Refer to Microsoft Article "Configuring Mail Profiles":
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_0r1w.asp
To set-up the Operator for Notification emails:
1. Start the SQL Server Enterprise Console, select Microsoft SQL Servers | SQL Server Group | [Your Server] | Management | Operators | right-click and choose new Operator.
Refer to Image1 in the attached file.
2. Choose an operator name and fill in the email address and click OK to save.
For more information on setting up Operator Properties, refer to Microsoft Article "Operator Object":
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dmoref_ob_o_29pw.asp
To set an alert on a task:
1. Ensure that the Maintenance Plan is open and the Tasks Tab is displayed.
2. In the Task List, select the desired task to set or modify alerts.
3. Select the Notification Pane, refer to Image 2 in the attached file.
A. To send an Email, Page, and/or Net Send Alert:
· Check the appropriate checkbox(es) (Email operator, Page operator and/or Net send operator).
· Select the Operator to receive the alert.
B. Specify when to generate the alert:
· When the job succeeds.
· When the job fails.
· When the job completes.
C. To write the event to the Windows Application Event log, check the Write to Windows Application Event log checkbox and select in what instance to write an event:
· When the job succeeds.
· When the job fails.
· When the job completes.
D To automatically delete a task from the Maintenance plan (based on a condition), check the Automatically delete job checkbox and select in what instance to delete the task:
· When the job succeeds.
· When the job fails.
· When the job completes.
4. Make any further changes to the Maintenance Plan as required and click OK when completed.
