June 6, 2008 at 4:17 am
I currently have a maintenance plan setup that backs up a set of around 16 databases, which has a notify operator when the job ends for Failure and Success. However last night the backup failed and the notify operator only tells you that the job failed and not which database has failed.
Is there a way to modify the Maintenance plan to show which database has failed, I have thought about separating the Backup Database command into 16 separate boxes and having a SUCCESS or FAILURE notify option for each but that seems a little excessive.
Any Ideas
Thanks
June 6, 2008 at 4:27 am
Not through the job history, but from the maintanace plan history (Right click on the maintanance plan)...we can get the details for each database which is a part of maintenance plan.
Renuka__
[font="Verdana"]Renuka__[/font]
June 6, 2008 at 4:57 am
I need to be able to get an email when the Job is successful and and email for each of the failed databases
June 6, 2008 at 4:08 pm
You could use the Maintenance Plan option [Send report to an e-mail recipient].
http://technet.microsoft.com/en-us/library/ms180370(SQL.100).aspx
You could also create an alert on the error number for a failed backups. Then you will know about all failed backups instantly.
Ola Hallengren
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply