I’m using Toad For Data Analysists 188.8.131.524. I’m connecting to an iSeries DB2 database.
I have a script that runs 20 SQL’s. If I run the script from the TOAD Automation Window by clicking TEST, it works properly. If I schedule the job, the sixth SQL (it is an INSERT SQL) keeps inserting records forever. I should see about 156,000 records in the file, but the SQL goes past the 156,000 and just keeps running.
There are other insert SQL’s prior to the sixth SQL, and they run ok.
So…it works ok by clicking TEST from the TOAD Automation Window, but runs into problems when it’s run as a scheduled job.
THe SQL causing the issue is attached.
Copy of 01B_INSERT_MC2SMARTA.sql (4.14 KB)