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