orcal job定时器

begin

DBMS_SCHEDULER.create_job(
job_name => 'JOB_P_GPIP_UPDATE_FEEDER_DL',
job_type => 'STORED_PROCEDURE',
job_action => 'P_GPIP_UPDATE_FEEDER_DL',
start_date =>sysdate,
enabled=>TRUE,
repeat_interval => 'FREQ=DAILY;BYHOUR=1;',
comments=> '描述存储过程名字');
end;
/