[PHP]
SQL> var v_jobno number
SQL> begin
2dbms_job.submit(
3:v_jobno,
4 'dbmsoutput;',
5sysdate+1/1440,
6'sysdate+10/1440/60'
7);
8commit;
9end ;
10/
PL/SQL procedure successfully completed
v_jobno
---------
27
SQL> exec dbms_job.run(27);
类似这种,, 10秒运行一次,,一分钟后执行
[/PHP] |
|