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 |
boreddy
Posting Yak Master
172 Posts |
Posted - 2011-03-16 : 05:59:06
|
Hi ExpertsI have one job which runs daily and it contains the total 43 steps in the first 10 steps belongs ssis packages are runningremining steps contain the sql scripts(sql statements)all steps runs in this waythe current step is failed or successed it goes to next stepi want the notification for the sql script steps fails for example if my 20 step is faild i have to get the mailin the same flow, 34 step is failed the i have get the mail to do this what can implement in my jobThanks in advance |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2011-03-16 : 10:22:20
|
DB Mail is the best way.get the information related to SMTP sever of your organization, and setup a DBmail. then in agent properties, you need to change the alerting to db mail. then in job properties set if the job failed send an email to your group.ArnavEven you learn 1%, Learn it with 100% confidence. |
 |
|
boreddy
Posting Yak Master
172 Posts |
Posted - 2011-03-16 : 10:57:52
|
Here is one problemour job steps runs like this if the step is failed or succes it goes to next stepthis job returns the failure when it reaches to last step i want the notification mail which step it is faild there itslefothere steps should run |
 |
|
|
|
|