(1):procedure
create or replace procedure aiki_test
asbegin
insert into aiki.a2 values('a',88);
commit;
end;
/
(2):创建job
begin
dbms_scheduler.create_job (
job_name => 'aiki_test2',
job_type => 'STORED_PROCEDURE',
job_action => 'aiki_test',
start_date => sysdate,
repeat_interval => 'FREQ=minutely; INTERVAL=3;',
comments => '系统临时测试'
);
end;
/
(3):启用
exec dbms_scheduler.enable('aiki_test2');