How can I tell if a job has completed?
567153Mar 15 2007 — edited Mar 15 2007I'm trying to use a single stored procedure to launch multiple instances of other stored procedures (which each look after a "search engine" type request).
I want to limit the number of parallel procedures running so I initiate up to 10 (with dbms_scheduler) and then sleep for a while before having a look if any of the jobs as completed..... But how do I test if any jobs have completed given that all I have is the job name??? Apparently this is possible but I'm rather inexperienced in Oracle and thus left a bit lost!
Any help?