把你创建job的脚本贴出来BEGIN
SYS.DBMS_JOB.REMOVE(463);
COMMIT;
END;
/DECLARE
X NUMBER;
BEGIN
SYS.DBMS_JOB.SUBMIT
( job => X
,what => 'WQGM_2V.PROC_TZ_ZYYWJL(to_char(sysdate,''yyyy-mm-dd'') ,''wqgm'' );'
,next_date => to_date('21/10/2014 00:00:00','dd/mm/yyyy hh24:mi:ss')
,interval => 'TRUNC(SYSDATE+1)'
,no_parse => FALSE
);
SYS.DBMS_OUTPUT.PUT_LINE('Job Number is: ' || to_char(x));
COMMIT;
END;
/
SYS.DBMS_JOB.REMOVE(463);
COMMIT;
END;
/DECLARE
X NUMBER;
BEGIN
SYS.DBMS_JOB.SUBMIT
( job => X
,what => 'WQGM_2V.PROC_TZ_ZYYWJL(to_char(sysdate,''yyyy-mm-dd'') ,''wqgm'' );'
,next_date => to_date('21/10/2014 00:00:00','dd/mm/yyyy hh24:mi:ss')
,interval => 'TRUNC(SYSDATE+1)'
,no_parse => FALSE
);
SYS.DBMS_OUTPUT.PUT_LINE('Job Number is: ' || to_char(x));
COMMIT;
END;
/
--添加定时任务
VARIABLE jobno number;↙begin
DBMS_JOB.SUBMIT(:jobno,
'你的存储过程;',
TRUNC(SYSDATE),'trunc(sysdate)+1');
commit;
end;
declare
job number;
begin
sys.dbms_job.submit(job,
'begin
WQGM_2V.PROC_TZ_ZYYWJL(to_char(sysdate,''yyyy-mm-dd'') ,''wqgm'' );
end;',
to_date('2014-10-22 00:00:00','yyyy-mm-dd hh24:mi:ss'),
'trunc(sysdate+1)');
commit;
end;
/
select job,last_date,next_date,broken,interval,failures from dba_jobs