Oracle 定时任务半小时执行一次的设置方法
1. 创建定时任务
<code class="SQL">BEGIN DBMS_SCHEDULER.CREATE_SCHEDULE( schedule_name => \'JOB_SCHEDULE\', start_date => SYSDATE, repeat_interval => \'FREQ=MINUTELY;INTERVAL=30\', end_date => NULL ); END; /
<code class="SQL">BEGIN DBMS_SCHEDULER.CREATE_SCHEDULE( schedule_name => \'JOB_SCHEDULE\', start_date => SYSDATE, repeat_interval => \'FREQ=MINUTELY;INTERVAL=30\', end_date => NULL ); END; /
之前