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;
/

腾讯云 12-20 广告
