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!

need help for how to alter oracle scheduler job interval for the job

946901Jul 2 2012 — edited Jul 2 2012
Hi,
I have the requirement to run job daily at particular time with out deleting current job from scheduler, can we alter in oracle scheduler job interval for the job with out creating new job.I am adding code,
for daily:repeat_interval => 'FREQ=daily;byhour=19;byminute=00;bysecond=00',

this is actual code

BEGIN
DBMS_SCHEDULER.create_job
(job_name => 'employee_mv_job_dblink',
job_type => 'PLSQL_BLOCK',
job_action => 'begin employee_mv_refresh@dblink;commit;end;',
start_date => SYSTIMESTAMP,
repeat_interval => 'FREQ=minutely;interval=1',
enabled => TRUE,
comments => 'Gather table statistics'
);
END;

thanks in advance
Ganesh
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 30 2012
Added on Jul 2 2012
2 comments
146 views