Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

oracle scheduler schedule job daily at 7AM and 7 PM

946901Jul 2 2012 — edited Jul 2 2012
Hi,
I have a requirement that i need to schedule a job using oracle scheduler daily at 7AM and 7 PM,presently i have
a code for scheduler which will run daily at 11O clock night which is working fine,i am adding that code,presently i am using 11G, Please help me.

BEGIN
DBMS_SCHEDULER.create_job

( job_name => 'employee_mv_job_dblink',
job_type => 'PLSQL_BLOCK',
job_action => 'begin employee_mv_refresh;commit;end;',
repeat_interval => 'FREQ=daily;dbyhour=23;byminute=0;bysecond=0 ',
enabled => TRUE,
comments => 'Test Auto Refresh'
);
END;

Thanks in Advance
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 30 2012
Added on Jul 2 2012
1 comment
1,539 views