how to edit a job created using dbms_scheduler
755708Mar 25 2010 — edited Mar 25 2010Hi,
This is my job which i have created, it will invoke p1() every 2 mins. Now i want to schedule it for every 10 mins. But i donno how to edit the job and change the repeat_interval => 'FREQ=MINUTELY;INTERVAL=10'
begin
dbms_scheduler.create_job(
job_name => Test_Job',
job_type => 'PLSQL_BLOCK',
job_action => 'begin p1(); end;',
repeat_interval => 'FREQ=MINUTELY; INTERVAL=2',
enabled => TRUE,
auto_drop => FALSE,
comments => 'Test job');
end;
can anyone help.
Thanks.