OraFAQ Forum: SQL & PL/SQL » dbms_scheduler -WeekDays scheduling program.

Home » SQL & PL/SQL » SQL & PL/SQL » dbms_scheduler -WeekDays scheduling program. (Oracle 11g, Windows)

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

dbms_scheduler -WeekDays scheduling program. [message #637288]

Thu, 14 May 2015 07:35

vicktorz
Messages: 26
Registered: March 2013

Junior Member

Dear Everone,

I'm looking for few information about dbms_scheduler.create_job.

I want the job should run only in weekday(i.e monday to friday , not in saturday and sunday).

could anyone please tell me how to change inpurt parameter for my requirement.

Quote:

dbms_scheduler.create_job(job_name => 'DIAL_STOP_MASTER_CHAIN_JOB',
job_type => 'STORED_PROCEDURE',
job_action => 'PR_DIAL_STOP_MASTER_CHAIN_JOB',
start_date => SYSTIMESTAMP,
end_date => '23-May-15 07.00.00.495180000 AM +01:00',
repeat_interval => 'freq=daily;byhour=12;byminute=0;bysecond=0',
enabled => TRUE,
auto_drop => TRUE,
comments => ' Schedular for DIAL_STOP_MASTER_CHAIN_JOB');

Thanks in Advance!!.

-Vijay

Report message to a moderator