SQL & PL/SQL

Hi,

I've got four event driven dbms_scheduler jobs which starts and runs simultaneously (i.e on the same event). Now two of these (3 & 4, which are the ones that executes in the least times) completes but the other two just disappears from user_scheduler_running_jobs without completing the processing.

I think I noticed a difference between the jobs that complete (3 & 4) and the ones that doesn't (1 & 2) when these were all scheduled. The jobs 3 & 4 were running on Instance 1 while jobs 1 & 2 were on Instance 2 (i.e user_scheduler_running_jobs.running_instance).

Since these jobs take a lot of time to complete and needs to be run on a daily basis, I got to wait till tomorrow to debug further.

If any of you guys got a clue what could be happening here, please let me know so that I could watch for that tomorrow.

Thanks,
CJM