OraFAQ Forum: SQL & PL/SQL » Sceduling a job to run on the 15th of every month?

Home » SQL & PL/SQL » SQL & PL/SQL » Sceduling a job to run on the 15th of every month?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Sceduling a job to run on the 15th of every month? [message #10938]

Wed, 25 February 2004 01:44

Dylan
Messages: 3
Registered: February 2004

Junior Member

I have a load of reports which need generated on the 15th of every month. I know to use dbms_job but am unsure how to get it to run on 15th every month. Any ideas on how to get these to run on this date would be great. Thanks, Dylan.

Report message to a moderator

Re: Sceduling a job to run on the 15th of every month? [message #10944 is a reply to message #10938]

Wed, 25 February 2004 04:38

ashok
Messages: 32
Registered: July 2000

Member

Try this :
============
VARIABLE jobno number;
BEGIN
DBMS_JOB.SUBMIT (
:jobno, --Job
'procedure_name', -- what to run
to_date('15-mar-04','dd-mon-yy') , -- First run
last_day(sysdate) + 15 ) ; --Interval
commit;
END;
/

Report message to a moderator