Hi all,
I am using Oracle 9.2 version and I had to run a stored procedure asynchronously. I was researching a little bit on this and found that Oracle jobs was a way to do it. Is this the only way or is there a way to run a stored procedure asynchronously?
Also, I had a question in using DBMS_JOBS package. Currently, if I decide to use jobs, I need to log new jobs every 6 minutes and the original transaction which logged the jobs has to continue without waiting for the jobs to finish. The problem with this is that the job queue can become very long after sometime. Is there a way to automatically remove the jobs from the job queue once it is finished?
Any pointers to this would be greatly helpful.
Thanks.