Re: Job Queue

Todd ¼¶¼g©ó¤å³¹ <7k233a$8gt$1_at_news.seed.net.tw>...
>We try to use the 'Job Queue' in our MIS system.
>
>I have submit a job in queue but it don't execute though dbm_jobs.run works
>fun.
>
>Are there somethings I do not know to let job queue works automatically?
>
I have issued commit after dbm_jobs.submit, and it can find in the user_jobs.
Here is my source

begin
dbms_job.submit(:jobno,'write_run''08806'',''JQ_TEST'',''JQ_TEST'',''1'',nul l);',sysdate,'sysdate+1/360');
commit;
end;
/
where wirte_run is a stored procedure.
Also, we have set job_queue_process to 2 and job_queue_interval to 120. But it doesn't excute after all. Received on Tue Jun 15 1999 - 05:07:08 CEST