Stored Procedure Job

• Simon-220850

  SSCrazy

  Points: 2789

  More actions

  April 10, 2006 at 9:58 am

  #112485

  Hi

  I'm having one of those I'm sure this is a simple answer days .  We have a stored procedure routine in a third party application, that is split into transactions and is scheduled as a job

  CREATE PROCEDURE

  BEGIN TRANSACTION A

  PROCESSING A

  COMMIT TRANSACTION A

   

  BEGIN TRANSACTION B

  PROCESSING B

  COMMIT TRANSACTION B

  GO

   

  PROCESSING A sometimes fails - this obviously rolls back the transaction.  PROCESSING B doesn't seem to occur at the moment.  Would people expect the job to process no further than PROCESSING A if it fails or would TRANSACTION A rollback and TRANBSACTION B attempt to run

  Cheers

   

   

• Antares686

  SSC Guru

  Points: 125444

  More actions

  April 10, 2006 at 1:01 pm

  #631814

  I would expect if A fails B never runs. But it depends on what A does and B does and if B relies on an ything produced in A.

• Simon-220850

  SSCrazy

  Points: 2789

  More actions

  April 12, 2006 at 3:38 am

  #632038

  Thanks

  This is what is happening

   

   

  Cheers