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 |
|
wotrac
Yak Posting Veteran
98 Posts |
 Posted - 2005-02-19 : 07:09:02
|
| Is it possible to create a scheduled job with multiple steps,where each subsequent step only executes if the previous stephas completed successfully. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-02-19 : 07:35:36
|
| Absolutely. Each step has On Success and On Failure actions, these default to "Go to Next Step" and "Quit with failure" respectively. You can change these to meet your needs, but you'll get almost exactly what you want from the defaults. |
 |
|
|
|
|
|
T-SQL Steps