Re: Job Queue

Todd ¼¶¼g©ó¤å³¹ <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?
>>
>
>
>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.
>
>
We have solved the problem. The only reason is you have set resource_limit = FALSE
in init.ora and then restart the server. Received on Wed Jun 16 1999 - 11:09:12 CEST