背景: 创建一个Oracle的定时任务,每天或指定时间
-----定义存储过程
create or replace procedure AAA_BBB as
begin
insert into AAA select * from BBB;
commit;
end;
----------------创建定时任务
declare
xjobid number;
begin
DBMS_JOB.SUBMIT(
JOB => xjobid,
WHAT => 'AAA_BBB;', ---这里的冒号很重要
NEXT_DATE => sysdate,
INTERVAL => 'TRUNC(SYSDATE+1)+(8*60+30)/(24*60)'
);
commit;
end;