通过Oracle JOB包定期执行数据统计
环境:Oracle Database 10g Enterprise Edition Release 10.1.0.2.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>
相关推荐
yangkang 2020-11-09
lbyd0 2020-11-17
sushuanglei 2020-11-12
85477104 2020-11-17
KANSYOUKYOU 2020-11-16
wushengyong 2020-10-28
lizhengjava 2020-11-13
星月情缘 2020-11-13
huangxiaoyun00 2020-11-13
luyong0 2020-11-08
腾讯soso团队 2020-11-06
Apsaravod 2020-11-05
PeterChangyb 2020-11-05
gaobudong 2020-11-04
wwwjun 2020-11-02
gyunwh 2020-11-02
EchoYY 2020-10-31
dingyahui 2020-10-30