oralce定时执行存储过程任务设置步骤详细
每天一点定时将A表新增的记录插入到B表
11、建立过程
2
3 insert tableA
4 (
5 select * from tableB
6 minus
7 select * from tableA
8 )
9
10 2、建立JOB
11 begin
12 sys.dbms_job.submit(job => :job,
13 what => 过程名;',
14 next_date => sysdate,
15 interval => 'trunc(sysdate+1,''dd'')+1/24');
16 commit;
17 end;
18 /
19
2
3 insert tableA
4 (
5 select * from tableB
6 minus
7 select * from tableA
8 )
9
10 2、建立JOB
11 begin
12 sys.dbms_job.submit(job => :job,
13 what => 过程名;',
14 next_date => sysdate,
15 interval => 'trunc(sysdate+1,''dd'')+1/24');
16 commit;
17 end;
18 /
19