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

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

SQL> prompt submitting to job queue...ITPUB个人空间u6^*StJ/Gh
submitting to job queue...

SQL> variable v_jobNum number
z1vQ `g Zy6| Mh7590422SQL>
1U*O0tTR5~7590422SQL> begin
oM
?!M#hV$O[2A7590422  2    sys.dbms_job.submit(job => :v_jobNum,
h"J$Cd2qD |Kj f2{7590422  3                        what => 'dev_new_product_bom;',
k8EdP{7590422  4                        next_date => sysdate,ITPUB个人空间I2v.|gSe5EV
  5                        interval => 'sysdate+(60/(24*60*60))');
'c@6M"eHw2_/_7590422  6    commit;ITPUB个人空间2ukD1r K_rA)h
  7  end;ITPUB个人空间
@'Tq3P*b#yN9b
  8  /

PL/SQL procedure successfully completedITPUB个人空间n7NO)je*uT6]m\
v_jobNum
m}z8KZp%a9I7590422---------
#bHT2r|:R\759042227