1 Reply Latest reply on May 3, 2013 6:37 AM by spajdy

    Setting a Job's starttime to a constant time independent of time transition


      Oracle version: Oracle Database 11g Release - 64bit Production+

      i want put a daily job (DBMS_SCHEDULER) with start_time = 1.30 a.m. and i want this job starts always at 1.30 a.m., indifferent of Summer/Winter Time. How?

      If i put this job as given:

      job_name          => 'MLR.JOB_MLR_REFRESH_MVIEWS',
      job_type          =>  'PLSQL_BLOCK',
      job_action        =>  '....',
      start_date        =>  to_timestamp('2013-05-02:01:30:00','YYYY-MM-DD:HH24:MI:SS'),
      repeat_interval   => 'FREQ=DAILY;INTERVAL=1;BYHOUR=1;BYMINUTE=30;BYSECOND=0',
      enabled  => TRUE,
      auto_drop  => FALSE);

      then i see

      start_date = '02.05.2013 01:30:00,000000 +02:00'

      This job will start at 1.30 a.m. in summer, and at 0.30 a.m. in winter. That is unwanted for me.

      Edited by: user8886932 on 02.05.2013 06:26