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
- Open the
AddNotificationOperator.sql
script in SQL Management Studio. - Set valid display name and email address values.
- Run the script.