求一个job的写法declare
jobno number;
begin
DBMS_JOB.SUBMIT(jobno,'pro;',sysdate,'');
commit;
end; 每年的第一天凌晨1点...
帮忙看看
jobno number;
begin
DBMS_JOB.SUBMIT(jobno,'pro;',sysdate,'');
commit;
end; 每年的第一天凌晨1点...
帮忙看看
------------------------------
2009-1-1 1:00:00SQL> --- job example
begin
sys.dbms_job.submit(job => :job,
what => 'check;',
next_date => to_date('15-05-2008 17:12:00', 'dd-mm-yyyy hh24:mi:ss'),
interval => 'add_months(trunc(sysdate,'yyyy'),12)+60/1440');
commit;
end;
jobno number;
begin
DBMS_JOB.SUBMIT(jobno,'pro;',sysdate,'ADD_MONTHS(trunc(sysdate,'yyyy'),12)+1/24');
commit;
end;
sys.dbms_job.submit(job => :job,
what => procedure_name;', --procedure_name用你的存贮过程代替
next_date => to_date('01-01-2009 01:00:00', 'dd-mm-yyyy hh24:mi:ss'),
interval => 'TRUNC(SYSDATE+365)');
commit;
end;
/
时间是没错,但为什么我写declare
jobno number;
begin
DBMS_JOB.SUBMIT(jobno,
'pro;',
to_date('01-01-2009 01:00:00', 'dd-mm-yyyy hh24:mi:ss'),
'add_months(trunc(sysdate,'yyyy'),12)+60/1440');
commit;
end; 报错误????
declare
jobno number;
begin
DBMS_JOB.SUBMIT(:jobno,
'pro;',
to_date('01-01-2009 01:00:00', 'dd-mm-yyyy hh24:mi:ss'),
'add_months(trunc(sysdate,'yyyy'),12)+60/1440');
commit;
end;
jobno number;
begin
DBMS_JOB.SUBMIT(jobno,'pro;',sysdate,'ADD_MONTHS(trunc(sysdate,''year''),12)+1/24');
commit;
end;