Hi all,

Very new to SQL, so forgive me if this is something obvious.

We have a single maintenance plan which has several sub-tasks. We are
trying to set things up so we get a single email alert if any of the
maintenance plan sub-tasks fail.

Right now we have done:
Management->Maintenance Plans->"maintenance plan"
Clicked on "reporting and logging" icon
Selected "send report to an email recipient"

I get emails every 2 hours when we run a transaction log backup, as
well as for each backup, shrink, re-index etc etc.

Can anyone suggest, or point me to a resource where we can learn how
to set things up in the way we want above? From searching, the only
thing we could find was doing some kind of customised scripting.

Thanks,
Raj

Instead of using the reporting option to send notification, you can add a
notify operator task to the sub-plan. Connect each task to the notify
operator task and change it to execute on failure. This will show up as a
solid red arrow pointing to the notify operator task. Now, this is the
important part - right-click on one of those dependencies and select the
properties. In the properties window, at the bottom change the AND to an OR
condition. This will change the dependencies to a dashed red line.

Configure the notify operator task with the appropriate operator and
message.

When any task fails - you'll now get a notification for the failure.

Jeff

"abd08" <dejaonly (AT) hotmail (DOT) com> wrote

Hi Jeff,

Thank you for your thought out and detailed reply. After following
your instructions, everything is now setup perfectly!

Thanks again,
Rajiv


On Feb 23, 2:33*am, "Jeffrey Williams" <jeff.williams3... (AT) verizon (DOT) net>
wrote:

Great - glad to hear it worked for you.

"abd08" <dejaonly (AT) hotmail (DOT) com> wrote