Can I force a COMMIT on a running job?

• Hawkeye_DBA

  SSCarpal Tunnel

  Points: 4365

  More actions

  June 18, 2009 at 8:41 am

  #135366

  I want to end a job that is running but it is wrapped in a transaction. Is there any way for me to end the job and still have it commit what has been processed so I don't have a huge rollback?

  Thanks for your help!

• Jeffrey Williams

  SSC Guru

  Points: 90314

  More actions

  June 18, 2009 at 10:20 am

  #1011913

  No - there is no way to do this and I wouldn't even want to be able to. You are just going to have to suffer the rollback if you kill the process.

  Jeffrey Williams
  “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

  ― Charles R. Swindoll

  How to post questions to get better answers faster
  Managing Transaction Logs