通过Oracle JOB包定期执行数据统计

2014-11-24 17:15:54 · 作者: · 浏览: 0

存储过程:MyProc


JOB编译:


SQL> declare
2 jobx number;
3 begin
4 sys.dbms_job.submit(job => jobx,
5 what => 'MyProc;',
6 next_date => trunc(sysdate+1) + 750/1440, //每天12:30执行
7 interval => 'trunc(sysdate+1) + 750/1440' //每天12:30执行
8 );
9
10 commit;
11 end;
12 /

PL/SQL procedure successfully completed

SQL>