How to use repeat_interval in create_job of dbms_scheduler
Hi,
Trying to execute a procedure repeatadly using job, but fails to execute.
The procedure, I am trying to execute is
create procedure p1 as
begin
insert into tab1 values ('ashish');
commit;
end;
/
where tab1 table is defined as
create table tab1( a varchar2(100) );
and the job I created as
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;
/
As I am new to scheduler, any help in details much appreciated.
Thanks