SQL Job behavior...Not Quit on Failure?

microsoft.public.sqlserver.programming

23 Mar 2006 2:37 AM

Atkins

I have a sql job that executes a stored procedure. The procedure just
iterates through a cursor and performs an update or insert and this
doesn't occur within a transaction.

If an insert or update fails will the job step quit on that first
failure?

I would like it to continue processing the other records. Is this
possible?

23 Mar 2006 9:04 AM

Tibor Karaszi

Agent TSQL jobstep does, for some reason, terminate on first error message returned. If you don't
like that, use a CmdExec job step instead.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/

Show quote

"Atkins" <michael.hurt***@cenveo.com> wrote in message
news:1143081448.109862.259380@t31g2000cwb.googlegroups.com...
>I have a sql job that executes a stored procedure. The procedure just
> iterates through a cursor and performs an update or insert and this
> doesn't occur within a transaction.
>
> If an insert or update fails will the job step quit on that first
> failure?
>
> I would like it to continue processing the other records. Is this
> possible?
>

31 Mar 2006 9:00 PM

Atkins

Thanks Tibor! I used the CmdExec job step to execute OSQL and it does
just what I want.