Re: Kill a job process

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Dan Guzman (guzmanda_at_nospam-online.sbcglobal.net)
Date: 11/03/04 

Date: Wed, 3 Nov 2004 08:22:28 -0600

No implicit transactions are created for jobs or job steps. It is entirely
your responsibility to handle transactions within a step and transactions
cannot span multiple steps.

If you need this functionality, consider using a multi-step DTS package. 

-- 
Hope this helps.
Dan Guzman
SQL Server MVP
"CB" <anonymous@discussions.microsoft.com> wrote in message 
news:2a4101c4c1ae$d60fda90$a401280a@phx.gbl...
> If you kill a job's process, is everything the job has
> done rolled back ie is the whole job run in a
> transaction? What about if the job used cursors?
> TIA,
> CB