oracle 添加定时任务
--submitselect * from reportnobenefit;variable job1 number;begindbms_job.submit(:job1,'PKG_JOBS.CALC_NOBENEFIT;', sysdate,'trunc(last_day(sysdate))+25/24'); end;--runbegindbms_job.run(222);commit;end;--removevariable job1 number;begindbms_job.remove(281);commit;end;select * from user_jobs;--查看调度任务select * from dba_jobs_running;--查看正在执行的调度任务select * from dba_jobs;--查看执行完的调度任务
