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 |
|
vaddi
Posting Yak Master
145 Posts |
 Posted - 2006-11-27 : 13:21:51
|
| Hello I have the sql server 2005 maintenance plan set up and I get a mail at the end , that the maintance plan has succeeded . I want to receive the mail only when something goes wrong in the steps like, database backup fails , turncate log fails.How can I do that.Thanks |
|
|
kowani1
Starting Member
42 Posts |
Posted - 2006-11-27 : 22:54:40
|
| Hi there,Unless 2005 is way different from 2000, are you not able to setup operators and then at the individual scheduled jobs level, specify to receive email notifications on failures, specifying individual operator, or a group of operators to whom the emails get sent to...jungle dba |
 |
|
|
vaddi
Posting Yak Master
145 Posts |
Posted - 2006-11-28 : 15:48:21
|
| HiI have the operators.When I schedule the job in the maintenance plan , and on the connecting arrow to the next job or to notify the operator I give the constraint failure. The task executes successfully but the job inside the task fails. That is when I want to receive an email.I have the maintenance plan like :Backup all databaseMaintenance clean up taskCheck database Integrityshrink databaseUpdate statiscits.So I want to receive a mail only if any of the jobs fail.I am including the notify operator after each step.But what should I give as a constraint or expression.Thanks |
|
|
|
|
|
|
Database Mail , when maintenance plan fails