17,086
社区成员
发帖
与我相关
我的任务
分享
SQL> variable job number;
SQL> begin
2 sys.dbms_job.submit(job => :job,
3 what => 'rgl_b_rjl_proc;',
4 next_date => to_date('18-09-2008 10:06:41', 'dd-mm-yyyy hh24:mi:ss'),
5 interval => 'sysdate+1/1440');
6 commit;
7 end;
8 /
PL/SQL procedure successfully completed