Job/Routine Trigger and Status Update Issue
Posted: Mon Feb 04, 2013 8:17 am
Hi,
We have a situation where we are using a routine (which takes SQL statement and submits to database - Oracle) to insert some of the data in 5 different tables.
Sample SQL;
INSERT INTO TABLE TARGET
SELECT COL1, COL2 .. from SOURCE
WHERE...
Query 1:
----------
I have 5 different instances (with different SQLs for different tables) of above routine running/triggered at the same time in sequence.
But when we see log then we come to know only 2 instances of that routine triggered and other instances followed them once they finished (though all the 5 instances should be triggered at the same time).
Query 2:
----------
We have another parallel job also running together with these 5 routines. That job started after one routine finished but strange is that job finish status has been updated in Sequence after 30 minute of actual finish. For Example job finished at 4 PM (we can see job finish time as last run) but log in sequence has updated at 4.30 PM which shows job finished.
Could you please help me identifying what could be the issue.
We have a situation where we are using a routine (which takes SQL statement and submits to database - Oracle) to insert some of the data in 5 different tables.
Sample SQL;
INSERT INTO TABLE TARGET
SELECT COL1, COL2 .. from SOURCE
WHERE...
Query 1:
----------
I have 5 different instances (with different SQLs for different tables) of above routine running/triggered at the same time in sequence.
But when we see log then we come to know only 2 instances of that routine triggered and other instances followed them once they finished (though all the 5 instances should be triggered at the same time).
Query 2:
----------
We have another parallel job also running together with these 5 routines. That job started after one routine finished but strange is that job finish status has been updated in Sequence after 30 minute of actual finish. For Example job finished at 4 PM (we can see job finish time as last run) but log in sequence has updated at 4.30 PM which shows job finished.
Could you please help me identifying what could be the issue.