Shared DB Connection autocommit

[Anonymous]

Hi,

I have a question about the shared DB connection between differents Jobs and the advanced option Auto commit.

For exemple, i open a connection in the parent job with a shared db connection and  whith th option Auto Commit.

in the child job , i use the shared connection, but i uncheck the option auto commit and validate the transaction at the end of the child job.

in this case i would like to know if the parent job will be save without transaction and if the child job will use the transaction.

Thanks for your help

Erwann

[akumar2301 · Accepted solution]

Share Db connection is static instance for a JOB .

So any change in Child job will persist.

[Anonymous]

Hi,

thanks for your answer,

So if I well understand, i have to modify the commit option after my sub job like this