Hello ,

I have setup a maintenance plan in sql server 2005.

My first step is backup of all databases.

In this task , all the databases are backedup.

But if any of the database backup fails , I need to get a mail.How can this be done.

Now in my plan whats happening is , as the task of the databases backup is successfully , its not sending an mail even if any of the databases backup fails.