procedures
代码：

create or replace procedure UP_EMPLOYEES as

begin

(相关sql语句)
update UP_EMPLOYEES
set xm='zhangsan'
where xh='1' 

commit;
end UP_EMPLOYEES;

job
相关
what：UP_EMPLOYEES; --定时任务的过程 
interval：trunc(sysdate,'hh')+1/(24) --执行时间每小时执行