Re: Job Queue
From: Todd <toddlee_at_ms4.url.com.tw>
Date: 15 Jun 1999 03:07:10 GMT
Message-ID: <7k4g0u$ef4$2_at_news.seed.net.tw>
Date: 15 Jun 1999 03:07:10 GMT
Message-ID: <7k4g0u$ef4$2_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?
>
[Quoted] I have issued commit after dbm_jobs.submit, and it could be seen in
user_jobs.
Here is my source
begin
dbms_job.submit(:jobno,'write_run
''08806'',''JQ_TEST'',''JQ_TEST'',''1'',null);',sysdate,'sysdate+1/360');
commit;
end;
/
where write_run is a stored procedure.
Also, we have set
job_queue_process = 2
job_queue_interval = 120.
But it does not execute after all.
Received on Tue Jun 15 1999 - 05:07:10 CEST