Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: dbms_jobs
Do you set the job_queue_processes and job_queue_interval parameters
in your init.ora file and restart the instance?
--
Have a nice day
Michel
zsolt.magyar <zsolt.magyar_at_sysdata.siemens.hu> a écrit dans le message :
3829588B.4EB171DE_at_sysdata.siemens.hu...
> Hi,
>
> I'd like to run for example every day a PL/SQL procedure. I used the
> dbms_job.submit procedure but it didn't work. I see the job in the
> user_jobs table, but it never run. I read the documentation and I have
> no more idea, what the problem could be.
> Any info is appreciated.
>
> DECLARE
> job_num BINARY_INTEGER;
> BEGIN
> dbms_job.submit(job_num, 'package.procedure;', sysdate, 'sysdate+1');
> commit;
> END;
> --
> Magyar Zsolt
> mailto:zsolt.magyar_at_sysdata.siemens.hu
>
>
Received on Wed Nov 10 1999 - 06:40:54 CST