摘要： -------------查询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;-------------修改JOB------ 阅读全文