Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This is my job design. I want to do tFileCopy_3 after all output tables such as productSpecs, SetUp, Order and OrderDetails's OnComponentOK is true. How do i catch the condition if onComponentOk on these tables are true? I want to copy file if only inserting data on these tables are true.
Hi,
1) Replace the OnComponentOk between both tFileList with a OnSubjobOk (more readable)
2) Move the tDBConnection before the first tFileList and add a OnSubjobOk link between them (to be sure the DB connection is made before the rest and that the job will stop if the connection fails)
3) Put your tFileCopy_3 below the tFileInputXML_1 after a OnSubjobOk link (to be sure the tFileCopy is made after the whole XML read/Oracle Input part)
4) I would personnaly remove the tRollback and add a tOracleClose (it's best to always close the connection and if you don't commit and close the connection, the rollback will be made)
You'll end up with somethind like this:
Regards