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 |
|
Van
Constraint Violating Yak Guru
462 Posts |
 Posted - 2009-05-21 : 11:45:19
|
| I have the need to have a job email a certain email address when it completes and also email a different email address only if it fails. Is this possible? I thought maybe using the pager email to send to for failure and use the email address rather than a pager address but it didn't work. Any ideas?Thanks,Van |
|
|
Van
Constraint Violating Yak Guru
462 Posts |
Posted - 2009-05-21 : 11:47:43
|
| Also, it's SQL 2005, SP2 and I'm using Database Mail...SMTP. |
 |
|
|
Van
Constraint Violating Yak Guru
462 Posts |
Posted - 2009-05-21 : 15:52:02
|
| Nevermind, I figured it out. Had the pager email set up wrong. It works now sending and email notification when the job completes and a pager notification to a different email address when it fails. |
|
|
|
|
|
|
Job notifications - tricky question