作者:萝莉控的小潴_515 | 来源:互联网 | 2023-07-19 15:30
环境: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>
Oracle通过job定时执行任务 2013-08/89408.htm
Linux-6-64下安装Oracle 12C笔记 2013-07/86805.htm
在CentOS 6.4下安装Oracle 11gR2(x64) 2014-02/97374.htm
Oracle 11gR2 在VMWare虚拟机中安装步骤 2013-09/89579p2.htm
Debian 下 安装 Oracle 11g XE R2 2014-03/98881.htm
:2014-08/104978.htm