oracle job Ïà¹Ø

begin
  sys.dbms_job.submit(job => :job,
                      what => 'p_apip_price_send;',
                      next_date => to_date('01-01-4000', 'dd-mm-yyyy'),
                      interval => 'sysdate+1');
  sys.dbms_job.broken(job => :job,
                      broken => true,
                      next_date => to_date('01-01-4000', 'dd-mm-yyyy'));
  commit;
end;
 
---------------------------------------
1¡¢°Ñinit.oraÖÐÈçÏÂÁ½¸ö²ÎÊý´ò¿ª
JOB_QUEUE_INTERVAL=60
JOB_QUEUE_PROCESSES=4
job_queue_keep_connections=true
\\λÖÃλÓÚ:D:\oracle\admin\alpha\pfileϵÄinit.oraÎļþÄÚ
2
sys.dbms_job.submit(job => :job,  --job±àºÅ£¬Î¨Ò»±êʶ
                                what => 'begin  --jobÄÚÈÝ£¬µ÷Óô洢¹ý³Ì£¬ÒÔbeginºÍend¿ªÍ·
                                                   insert_t2;
                                  &nbs