dbms_jobs

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 - 05:35:40 CST