17,377
社区成员
发帖
与我相关
我的任务
分享
BEGIN
SYS.DBMS_JOB.SUBMIT
( job =>:job,
what => 'kq_num1;',
next_date => to_date('2010-06-26 01:00:00','yyyy-mm-dd hh24:mi:ss'),
interval => 'trunc(sysdate)+1+1/24',
no_parse => FALSE
);
COMMIT;
END;
begin
sys.dbms_job.submit(job => :job,
what => '--统计
wz_tj(null,null);
ck_tj(null);',
next_date => to_date('01-07-2010 00:18:00', 'dd-mm-yyyy hh24:mi:ss'),
interval => 'ADD_MONTHS(TRUNC(SYSDATE,''MM''),1)+0.3/24');
commit;
end;
/
BEGIN
SYS.DBMS_JOB.SUBMIT
( job =>job,--或job =>'job'或job =>263 全是错
what => 'kq_num1;',
next_date => to_date('2010-06-26 01:00:00','yyyy-mm-dd hh24:mi:ss'),
interval => 'trunc(sysdate)+1+1/24',
no_parse => FALSE
);
COMMIT;
END;