Submit a job to run every month.
573274Sep 28 2010 — edited Sep 28 2010Hi,
I have Oracle-10g DB and I am new to job scheduling. I need to schedule a job that calls a procedure every month on the first. The procedure takes two dates as parameter and inserts transactions for the entire month (between the two dates) into a table. Could you please let me know how to schedule the job for the below script on the 1st of every month? I am giving the script below that I run manually.
EXEC XX_VOUCH_SUM(to_date('07\01\2010 01:00:00','MM\DD\YYYY HH24:MI:SS'),to_date('07\31\2010 23:59:59','MM\DD\YYYY HH24:MI:SS'))
I appreciate an early response.
Regards,
Raj.