title: job scheduling for a few hours everyday
body: <p>I need to schedule a job starting from 0600 till 1800. The job should run after every two hours. For example 0800, 1000, 1200, 1400, 1600, 1800. </p>
  
  <p>Here is the code I have managed to do so far:</p>
  
  <pre><code>DECLARE
       l_id binary_integer;
       begin
         sys.dbms_job.submit(job =&gt; l_id, what =&gt; 'integration_export;', interval =&gt; 'TRUNC(SYSDATE,''hh24'')+0/24/60');
         sys.dbms_output.put_line(l_id);    
  end; 
  </code></pre>
  
  <p>This will, of course, run the job after every 2 hours without stopping at 1801 - 0759. How may I add this restriction? 
  One thing I though is to create another schedule procedure which wakes up at 1801 and changes NEXT_DATE for this job. However, I am wondering if it is a good idea.</p>
  
  <p>Any suggestions?</p>
  
  <p>Thanks in advance :-)</p>