Oracle创建定时任务调用存储过程

1.创建一个测试表test

create table test(time date);

2.创建一个存储过程

create or replace procedure test as

begin

insert into test values(sysdate);

end;

3.定时任务样板

declare

job1 number;

begin

dbms_job.submit(job1,

what => ‘test;’,

next_date => sysdate,

interval => ‘sysdate+1/(246060)’); – 每隔1s处理一次用户表

commit;

end;

4.查询定时任务

select job,broken,what,interval,t.* from user_jobs t;