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


                    
                    
            

