[原创]在ORACLE数据库提交JOB（作业）的例子！

这几天写一个程序，需要ORACLE自动运行一个过程，几翻周折终于成功提交了，发出来和大家共享！

SQL> prompt submitting to job queue...ITPUB个人空间2EvM*\!sEL.YWB8K
submitting to job queue...

SQL> variable v_jobNum numberITPUB个人空间d*l1yVyu yZY
SQL>
H'Iii a `+@w0SQL> begin
7l
I1ac]`0  2    sys.dbms_job.submit(job => :v_jobNum,ITPUB个人空间{XEQI7W-\
  3                        what => 'dev_new_product_bom;',ITPUB个人空间 [1o x0p&n8p$~"zp'X
  4                        next_date => sysdate,ITPUB个人空间`FGm+X7f%K
  5                        interval => 'sysdate+(60/(24*60*60))');
Zi!b#gf `:sa'U0  6    commit;ITPUB个人空间,oF rSM
  7  end;ITPUB个人空间 B-II-_s5n pb+f
  8  /

PL/SQL procedure successfully completed
s&I P4iyaz.NAXO2U0v_jobNum
dm0syRfd0---------

qV4M%X R6`M3A@D4~027