Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

Begin/Commit/Rollback

Hello,
one question regarding the usage of Begin/Commit/Rollback Components:
Are there any restrictions or limitations regarding the usage of Begin/Commit/Rollback?

I think about limitations regarding runtime of a job that use Begin/Rollback/Commit, for example a job needs 15 minutes to update a table or a huge count of table update transactions in a job.

I only found a information reagarding this in Matillion documentation:
"If you forget to commit or rollback after starting a transaction, the transaction will be left open (and continue to hold any associated locks) but only for a few minutes, after which the connection will be closed and an automatic rollback will be performed."

This means for me that i not have any limitations at usage of Begin/Commit/Rollback, is that correct?

Best regards,
Dirk

2 Community Answers

Matillion Agent  

Paul Johnson —

Hi Dirk,
The automatic rollback only occurs if the job you are running has a begin component but no commit component. If it has both the begin and commit components there are no limits on how long that job can run for.

Regards,
Paul


Dirk Zimmermann —

Perfect, many thanks for the fast (and positiv) response.
Regards,
Dirk

Post Your Community Answer

To add an answer please login