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 |
|
carumuga
Posting Yak Master
174 Posts |
 Posted - 2009-10-20 : 08:04:45
|
| Hi,I need to send the email notification either on success or failure.In the Job properties->Notification page, I have choosen Email and its id and gets triggered "when the job succeeds". But at the same time, the system should notify the operator when the job fails via Mail.Is it possible to configure both for success and failure...in this page.Thanks in advance. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-10-20 : 08:07:33
|
| you can write logic in next steps in jobs with sp_dbsendmail for both success and failure. |
 |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-10-20 : 08:13:23
|
| You can either select the option to send notification if job fails / succeeds/ completes.Have you tried selecting "When the job completes" ? |
|
|
|
|
|
|
Notifications