Automatic Procedure Execution

[agasimani]

I want to execute a procedure everyday at 12 O'Clock automatically. This procedure has some parameters as well. Can somebody tell me step by step how can I go ahead about it? I have Oracle 8.1.6 installed on Sun Solaris.

[pando]

program it with dbms_job, something like

in sql*plus

variable jobno number
exec dbms_job.submit(JOB => :jobno, -
WHAT => 'YOUR_PROCEDURE;',-
NEXT_DATE => trunc(SYSDATE+1,'DD')+1/12,-
INTERVAL => 'trunc(SYSDATE+1, ''DD''+1/12');

change next_date and interval for your own needs

remember set init.ora parameter job_processes to a value bigger than 0 since these scheduled processes are run by job processes

[kmesser]

Could you schedule it as an OS (cron) job?