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 |
|
Sun Foster
Aged Yak Warrior
515 Posts |
 Posted - 2007-11-21 : 09:45:53
|
| I use code below to run a job:if something...beginstep 1step 2...step 3endThe problem is if any step has an error, entire job will stop running.How to code to make job keep on running regardless an error within any step? |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-11-21 : 09:48:37
|
| well the exiting of the connection depends on the error severity.you could try try...catch blocks_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
 |
|
|
Pace
Constraint Violating Yak Guru
264 Posts |
Posted - 2007-11-21 : 10:24:29
|
Or make the steps as a sql agent job and set the options for "on failure" of a step to continue to next step? Would that work?... transactions..."Impossible is Nothing"  |
|
|
|
Sun Foster
Aged Yak Warrior
515 Posts |
Posted - 2007-11-21 : 10:52:06
|
| Yes, how to code?In VBA, code like "On Error Resume Next" |
|
|
|
|
|
|
How to keep on excute regardless an error?