Post reply

implicit transaction with a SQL SERVER Agent job

  • June 26, 2013 at 3:51 am

    #279167

    Good Morning.

    Is possible to change the isolation level for a job, or to do that the Agent not initialize a transaction for a job?

    Thanks.

  • June 26, 2013 at 3:55 am

    #1627449

    You can use the SET TRANSACTION ISOLATION LEVEL statement in the code for each job step. Please will you be more specific about what you're trying to achieve - we may be able to suggest a better way?

    John

  • June 26, 2013 at 4:52 am

    #1627463

    I will change my question:

    do SQL Agent initialize a transaction for each step although I don't initialize a transaction in the code of the step?

    Thanks.

  • June 26, 2013 at 6:40 am

    #1627523

    No, the code in the job step does not run as a single transaction (unless it consists of a single statement, of course). You would need a BEGIN TRANSACTION...END TRANSACTION wrapper if you wanted it to run as a transaction.

    John

Viewing 4 posts - 1 through 3 (of 3 total)

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