I am trying to create a Rollback and Commit Job. I am using tOracleCommit and Rollback component as my starting point.
However the job is asking for Component List and I am not getting anything in the list.
What is the issue here? can you please help?
To use these components, you have to use a tOracleConnection component. Configure one with the necessary settings at the start of the job (ideally, connected to a tPrejob component), and have the output, commit and rollback components refer to it. You may also want to configure a tOracleClose component connected to tPostjob.
Are you suggesting some thing like below or correct me if i am wrong. Ideally commit or rollback should mean either all the rows are committed or rolled back.Will this give the desired result?