SQL Server notifications

If the SQL Server Notification Service is installed and enabled, the backup jobs can be configured to send email notifications upon success, failure, or both.

About this task

Using SQL Notification Service requires the creation of an Operator. To assist, an extra script, AddNotificationOperator.sql, is created during the installation process in the same directory as the backup scripts.

To create the operator:

Procedure

  1. Open the AddNotificationOperator.sql script in SQL Management Studio.
  2. Set valid display name and email address values.
  3. Run the script.