创建一个测试表和一个存储过程: [sql] view plain copy print ? create table a(a date); create or replace procedure test as begin insert into a values(sysdate); end; 定时任务样板: [sql] view plain copy print ? declare job1 number; begin dbms_job.submit(job1, what => 'test;', next_date => sysdate, interval => 'sysdate+1/(24*60*60)'); -- 每隔1s处理一次用户表 commit; end; 查询定时任务: [sql] view plain copy print ? select job,broken,what,interval,t.* from user_jobs t; 删除定时任务: [sql] view plain copy print ? begin dbms_job.remove('24'); commit; end; Interval => TRUNC(sysdate+1) --每天凌晨0点执行 Interval => TRUNC(sysdate+1)+1/24 --每天凌晨1点执行 启动定时任务: [sql] view plain copy print ? begin dbms_job.run(24); -- 24jod id -- commit; end;