orcle job的一些操作

来源：互联网发布：策城软件怎么样编辑：程序博客网时间：2024/05/29 19:23

-------------查询JOB-----------------
select job, what, next_date, next_sec, sysdate, failures, broken,interval
from user_jobs a;
-------------创建JOB-----------------
DECLARE job_country_warnRecord NUMBER;
begin
dbms_job.submit(job => job_country_warnRecord,
what => 'WARNRECORD_PKG.proc_timerTask_warnRecord;',
next_date => TRUNC(SYSDATE)+8/24,
interval => 'TRUNC(sysdate) + 1 +8/(24)');
commit;
end;
-------------修改JOB-----------------
begin
dbms_job.change(62 ,job_country_warnRecord;', sysdate,'sysdate+2/(24*60)' );
commit;
end;
begin
dbms_job.change(62 ,job_country_warnRecord;', to_date('2011-08-01 22:00:00', 'yyyy-mm-dd hh24:mi:ss'),'sysdate+1');

dbms_job.change(124 ,ALL_UUM_PROC(2400);, to_date('2013-11-02 01:00:00', 'yyyy-mm-dd hh24:mi:ss'),'TRUNC(sysdate)+1+1/24');
commit;
end;
-------------删除JOB-----------------
begin
dbms_job.remove(41); //41为Job 的ID值
end;

dbms_ijob.broken(1,true);

declare
gbpx_job number;
begin
sys.dbms_job.submit(gbpx_job,'gbpxztqkb_proc;',sysdate,'TRUNC(sysdate)+1+2/24');
commit;
dbms_job.run(gbpx_job);
commit;
end;
begin
dbms_job.change(362,null,TRUNC(sysdate)+1+3/24,'TRUNC(sysdate)+1+3/24');
commit;
end;

SELECT * from dba_jobs_running;

-----------------------------------------------------------------------------------
手机app、网站开发、系统定制优惠中。。。
详情请登录http://www.junchuangsoft.com/