title: How to set start_date and end_date on a dbms job (oracle)
body: <p>I'm creating a scheduler for my oracle DB This is what i got so far :</p>
  
  <pre><code>BEGIN 
  DBMS_SCHEDULER.CREATE_JOB (
  job_name            =&gt; 'CREAZIONE_OCCORRENZE',
  job_type            =&gt; 'STORED_PROCEDURE',
  job_action          =&gt; 'pop_occr_lezione'
  start_date          =&gt;  A,
  end_date            =&gt;  B,
  repeat_interval     =&gt; 'FREQ=WEEKLY'
  enabled             =&gt; true,
  auto_drop           =&gt; false;
  )
  END;
  BEGIN
  DBMS_SCHEDULER.CREATE_JOB (
  job_name            =&gt; 'ASSEGNAZIONE - AULE',
  job_type            =&gt; 'STORED_PROCEDURE',
  job_action          =&gt; 'ass_aule'
  start_date          =&gt;  C,
  end_date            =&gt;  D,
  repeat_interval     =&gt; 'FREQ=WEEKLY'
  enabled             =&gt; true,
  auto_drop           =&gt; false;
  )
  END;
  /
  </code></pre>
  
  <p>As you see i still need to set start_date and end_date for the 2 jobs. Wich is rather confusing, how can i set :</p>
  
  <p>A = the last monday of august ( valid for each year )</p>
  
  <p>B = the first monday of august ( a year later of A )</p>
  
  <p>C = the first sunday after A</p>
  
  <p>D = the first sunday after B</p>
  
  <p>how can i do such a thing ?</p>