title: Alter an oracle job to run every 5 seconds from a specific time till a specific time everyday
body: <p>EDIT:  I need the below job to run from 11PM till 05:35AM, every 5 seconds in that window, everyday.</p>
  
  <p>So, what I've done so far is set the following to run every 5 seconds.</p>
  
  <pre><code>BEGIN
  
  DBMS_SCHEDULER.SET_ATTRIBUTE (
      name =&gt; 'test_job',
      attribute =&gt; 'repeat_interval',
      value =&gt; 'freq=secondly;bysecond=5;'
  );
  
  END;
  </code></pre>
  
  <p>then the start_date and end_date to make it run from 9PM of today till 05:35AM of tomorrow. </p>
  
  <pre><code>BEGIN
  
  DBMS_SCHEDULER.SET_ATTRIBUTE (
      name =&gt; 'test_job',
      attribute =&gt; 'start_date',
      value =&gt; TO_TIMESTAMP_TZ('2018-01-29 21:00:00.000000000 EUROPE/BERLIN','YYYY-MM-DD HH24:MI:SS.FF TZR')
  );
  
  END;
  
  BEGIN
  
  DBMS_SCHEDULER.SET_ATTRIBUTE (
      name =&gt; 'test_job',
     attribute =&gt; 'end_date',
      value =&gt; TO_TIMESTAMP_TZ('2018-01-30 05:35:00.000000000 EUROPE/BERLIN','YYYY-MM-DD HH24:MI:SS.FF TZR')
  );
  
  END;
  </code></pre>
  
  <p>Now the problem is that this is going to run once. I'm not sure how to make it run daily without giving up the every 5 second rule. I'm assuming I might need to use start_date and duration and omit end_date to achieve my goal, although I'm not sure how to specify duration.</p>