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 : 07:24:45
|
| Hi ExpertsI have one job which runs daily and it contains the total 43 stepsin 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 mailto do this what can implement in my jobThanks in advance |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-03-16 : 21:14:05
|
| The last step of all of my jobs is a failure notification which emails/pages the DBA group.Every *real* step goes to that step on failure.The last *real* step quits the job reporting success |
 |
|
|
|
|
|
How set notification in sql job