Transactions in Jobs

• Ramesh Saive

  SSC-Insane

  Points: 24275

  More actions

  March 2, 2007 at 8:14 am

  #72632

  Hi experts,

  This is a kind of urgency...

  I am running a job which does some processing in a single transaction & the job is still running.  I just want to know what would be the effect of stopping the job on the explicit transactions?  Do the server rollback all the transactions?

   

  --Ramesh
  

  ---

• SQLBill

  SSC Guru

  Points: 51440

  More actions

  March 2, 2007 at 11:42 am

  #692910

  Not necessarily. I suggest you run the rollback commands manually.

  -SQLBill