job scheduler step failed

  • Hi,

    I have a job scheduler with 5 steps to run. If step 3 encounters an error and fail, will the previous jobs rollback? Or the 1st 2 steps are completed and commited and only step 3 is rolled back?

    The first 2 steps are dbbc commands.

    Need someone to enlighten me. Thank you.

  • what ever the commands in step 1 and step2... it will not rollback..

     

    MohammedU
    Microsoft SQL Server MVP

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply