SQL Backup Master Help
Use the configuration options outlined below to enable backup job notifications from SQL Backup Master.
Send Notifications On
•Full backups - Send notifications when full backups succeed, warn, error, or fail.
•Differential backups - Send notifications when differential backups succeed, warn, error, or fail.
•Transaction log backups - Send notification when transaction log backups succeed, warn, error, or fail.
Email Notifications
When enabled, SQL Backup Master will send backup job notifications via email.
•Subject - Click the Edit button to customize the outbound notification email subject to suit your preferences.
•Recipient(s) - The email address(es) of the notification recipient(s). If you wish to enter multiple email addresses, separate them with a comma.
•Send failure notifications separately - Use this option to send failure (and errored) notifications to a separate email address(es).
IMPORTANT: Use of email notifications requires that you specify a mail server configuration.
Webhook Notifications
Webhook notifications can be used to send backup job completion messages to a wide variety of services such as Slack, PagerDuty, and more.
Webhooks must first be added and configured to the global Webhooks view. Once added, they can be selected for notification within any backup job.
Desktop Notifications
When enabled, SQL Backup Master will show backup job notification messages on the Windows desktop. This requires installation of the tray notification component, offered as a separate option during program installation.
Notification Variables
The following variables may be used in webhook and email notification templates.
%%jobname%% |
Name of backup job that was executed |
%%jobstatus%% |
Status of executed job (Finished, Warning, Errored, or Failed) |
%%backuptype%% |
Type of backup (Full, Differential, or Transaction Log) |
%%appname%% |
Name of this program (SQL Backup Master) |
%%machinename%% |
Name of the host computer |
%%date%% |
Current date (short format) |
%%time%% |
Current time (short format) |
Example use of above variables to formulate an email notification subject line:
{appname} Notification - Job {jobstatus} on "{machinename}"
Send Webhook Notifications
Select one or more webhooks that should receive notifications for this backup job.
Webhooks are configured in the global options window.
