Microsoft® SQL Server 2012 Unleashed

Defining Job Notifications

The Notifications page of the Job Properties dialog, as shown in Figure 13.13, allows you to define the notification actions to perform when a job completes.

FIGURE 13.13 The Notifications page of the Job Properties dialog.

As discussed earlier in this chapter, notifications can be sent via email, pager, or NET SEND command. The notifications for a Schedule Job can be sent based on the following events:

When the job succeeds

When the job fails

When the job completes

Each of these events can have a different notification ...