procedure

hi,
i want to run a procedure automatically at a particular time every day.

can someone help with an example for the same.


thax

regards

Most shops use the OS or a schedular like AppWorx to submit a procedure on a timed basis.

What OS, version of Oracle?

hi,
thanx for u r reply.i just came across this:dbms_job in the oracle doc, but not sure how to use it.if u can just explain this with an example i would appreciate it.






regards

I got it from oracle document and psot it same as it is:

For example, consider the following statements that submit a new job to the job queue, then prints the job number. The job calls the procedure DBMS_DDL.ANALYZE_OBJECT to generate statistics for the table hr.employees. The statistics are based on a sample of half the rows of the employees table. The job is run every 24 hours.

VARIABLE jobno NUMBER
BEGIN
DBMS_JOB.SUBMIT(:jobno,
'DBMS_DDL.ANALYZE_OBJECT(''TABLE'',
''HR'', ''EMPLOYEES'',
''ESTIMATE'', NULL, 50);',
SYSDATE, 'SYSDATE + 1');
COMMIT;
END;
/
PRINT jobno
JOBNO
----------
14144