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 |
|
nlocklin
Yak Posting Veteran
69 Posts |
 Posted - 2004-04-27 : 15:10:29
|
| Hello,I am creating a SQL Agent job that executes several DTS Packages in a row (they need to execute one right after the other).I see that there are options for: quit job reporting failure, continue with next step, etc. Is it possible to set up a SQL Agent job to continue with the next step reporting failure?I would like the DTS Packages to fire one after another. I don't want the job to stop if one of the packages fails, but at the same time I'd like to have the overall job status be failure if any one of the DTS packages failed.Is that possible? Any light that could be shed would be much appreciated!--"It's not that I'm lazy... it's that I just don't care." |
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2004-04-27 : 15:36:54
|
| I would create a single DTS and incorperate your "on Fail" notifications right in the Package.JimUsers <> Logic |
 |
|
|
|
|
|
Reporting failure from SQL Agent jobs