10g里使用dbms_scheduler的例子

beginITPUB个人空间%|GB&bzl
dbms_scheduler.create_jobITPUB个人空间l1\"\x7N-Q%DN
( job_name => 'send_mail',
yS'}mzaz3q7590422job_type => 'STORED_PROCEDURE',ITPUB个人空间]#r'VEj9m'kl
job_action => 'send_mail',ITPUB个人空间%RFg)lq!_
start_date => to_timestamp('2007-01-30 08:00:00','yyyy-mm-dd hh24:mi:ss'),ITPUB个人空间)D%MS3Nb7d1j_f i
repeat_interval => 'FREQ=MINUTELY;INTERVAL=10',ITPUB个人空间x;j[+J#f_i/b!t
end_date => to_timestamp('2020-01-30 08:00:00','yyyy-mm-dd hh24:mi:ss'),ITPUB个人空间p-~\.`;nK T7S/n
enabled => TRUE,ITPUB个人空间`OIk+@
comments => '10分钟发送一次邮件'ITPUB个人空间Xap;V9N&wS\!Puv
);
%{5HRpS'FXp7590422end;

查看：select * from user_SCHEDULER_JOBS;

停止：EXEC dbms_scheduler.disable('SEND_MAIL');

修改：

begin

DBMS_SCHEDULER.SET_ATTRIBUTE ('SEND_MAIL','repeat_interval','freq=daily;BYHOUR=0,12');

end;