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 |
|
jpotucek
Constraint Violating Yak Guru
273 Posts |
 Posted - 2008-01-28 : 13:39:49
|
| OK.. I'm finally getting around to setting up my notifications on my SQL Server 2000 Instances.. What I did was setup xp_sendmail as a last step in my maintenance plan (on my test box) most of my maintenance plans are only one step (a full backup) so I manually added a step to the maintenance plan JOB and set Step 1 to go to step 2 upon failure. It works GREAT !!!! However, SQL Server ENT Manager does complain a little when I look at the maintenance plan propertie. It complains about not liking the fact that I manually added a step. Does anyone see anything inherently wrong with this??????? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-28 : 21:02:39
|
| Not really. |
 |
|
|
donpolix
Yak Posting Veteran
97 Posts |
Posted - 2008-01-29 : 12:59:19
|
| Nah, it's just to remind you.Or you may want to use the Notifications tab in the job.Donn Policarpio |
|
|
|
|
|
|
Manually setting up SMTP email notifications