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