---创建存储过程: create or replace procedure pro_jggl as begin insert into wangliang_linshia values (sys_guid(), 'JOB修改数据:(' || to_char(sysdate, 'yyyy-mm-dd hh24:mi:ss') || ')'); commit; end; ----查看存储过程 select text from user_source where name = 'pro_jggl' and type = 'procedure'; ----创建定时器: declare jobno number; begin dbms_job.submit(job=> jobno,what=>'pro_jggl;',next_date=>sysdate,interval=>'TRUNC(sysdate,'mi')+1/(24*60)'); commit; end; ----删除定时器: begin dbms_job.remove(62); end; -----查看定时器是否运行 select * from user_jobs;/**当前用户的job**/
参考博客:https://www.cnblogs.com/advocate/archive/2010/05/05/1728218.html