oracle10g dbms_scheduler.create_job 创建job简单实例

(1):procedure

create or replace procedure aiki_test

as
begin
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');