oracle job

 

/*
declare
proc_BDDJ3_update number;
BEGIN
DBMS_JOB.SUBMIT(
JOB => proc_BDDJ3_update, \*自动生成JOB_ID*\
WHAT => 'proc_BDDJ3_update;', \*需要执行的存储过程名称或SQL语句*\
NEXT_DATE => sysdate, \*初次执行时间*\
INTERVAL => 'TRUNC(SYSDATE+1)+(8*60+30)/(24*60)' \*每天8点30分执行*\
);
commit;
end;