© Bradley Beard 2016

Bradley Beard, Practical Maintenance Plans in SQL Server, 10.1007/978-1-4842-1895-2_12

12. Notifying Database Operators

Bradley Beard

(1)Palm Bay, Florida, USA

The purpose of the Notify Operator Task is specifically to set up a notification task. It can be for any event within the plan; that is, the takeaway for this one. It doesn’t have to be tied to any specific task either. You could conceivably have this task, by itself, and all it will do is notify an operator. What good could that possibly do? If this task is tied to nothing else, what could a simple notification do? Let’s look at how to set it up and I will explain the answer to that question as we go.

Setting Up the Maintenance Plan

Right-click Maintenance Plans and choose ...

Get Practical Maintenance Plans in SQL Server: Automation for the DBA now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.