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 |
|
sanmeets
Starting Member
3 Posts |
 Posted - 2003-02-28 : 11:09:29
|
| I have email notification setup on job failure. Some steps in the job are not related and hence set to "Go to next step" if a step fails. Issue is if the step fails, no email notification is sent out because it is set to "Go to next step" and the job eventually succeeds.Is there any way to send email out at step level even if the job succeeds in the end. I can seperate each step into distinct jobs but I would like to avoid that due to huge number of steps and adminstrative reasons.thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-02-28 : 12:31:08
|
| Why don't you just use xp_sendmail in one of the tasks? |
 |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2003-02-28 : 12:34:24
|
| You have can do few things:1. Write a custom ActiveX script that executes each step of a DTS package and performs some action according to results returned by performing that step.2. Have the DTS write out to a log table in the database the results of each step. As a last step in the package read the log table and email results.3. Turn on DTS logging in the options and examine the log to see the results.4. ExecuteStep1 --> On Failure --> Email --> ExecuteStep2ExecuteStep1 --> On Success --> ExecuteStep2Edited by - ValterBorges on 02/28/2003 12:35:25Edited by - ValterBorges on 02/28/2003 13:10:05 |
|
|
|
|
|
|
Email Notification on Job Failure