Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
 Posted - 2010-07-08 : 08:36:52
|
| Hi,I am using the maintanance plan to back up the 5 databases. and created a notification operator task to notify the user.But in the message body i need to give a custom message for different databases.For Ex; If database A fails then i need to send a msg like "The Database A backup got failed 2010-07-07" Please help me how can we do this.Thanks,Gangadhar |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2010-07-08 : 21:55:22
|
| The only way you can do this is to create multiple backup tasks (one for each database), with it's own notify operator task. You can set this up to have the backups run parallel, or sequentially. If sequential, change the dependency to move to the next task on completion so the other backups will be performed even if the first backup task fails. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2010-07-09 : 16:24:33
|
quote:
Originally posted by jeffw8713
The only way you can do this is to create multiple backup tasks (one for each database), with it's own notify operator task. You can set this up to have the backups run parallel, or sequentially. If sequential, change the dependency to move to the next task on completion so the other backups will be performed even if the first backup task fails.
Or, you could use Tara's script in a single Execute SQL Task in a single maintenance plan.That is - if you *have* to use a maintenance plan :) |
|
|
|
|
|
|
Maintanance plan Notification