oracle_job

--------------查询------------------------

select job, what, next_date, next_sec, sysdate, failures, broken,interval  from user_jobs a;

-------------添加JOB-----------------
variable n number;

begin
  dbms_job.submit(:n, 'MY_JOP;', sysdate,'sysdate+2/(24*60*60)');
  commit;
end;

-------------------添加-------------------------------

declare
 
v_job number :=1;
 
begin
 
dbms_job.submit(v_job,'sp_fact_charge_code;',sysdate,'sysdate+1/1440');
 
commit;
 
end;

-------------修改JOB-----------------
begin
  dbms_job.change(62 ,'MY_JOP;', sysdate,'sysdate+2/(24*60)' );
  commit;
end;

begin
  dbms_job.change(62 ,'MY_JOP;', to_date('2011-08-01 22:00:00', 'yyyy-mm-dd hh24:mi:ss'),'sysdate+1');
  commit;
end;

-------------删除JOB-----------------
begin
 dbms_job.remove(41);
end;