title: Oracle DBMS_AUDIT_MGMT.CREATE_PURGE_JOB at a specifc time of day
body: <p>I am trying to figure out how I can create/schedule a DBMS_AUDIT_MGMT.CREATE_PURGE_JOB to execute at a specific time of day, rather than at the interval,
  which appears to start at the time you execute the CREATE_PURGE_JOB ?</p>
  
  <p>The only thing I can think of is to change the SYSTEM time temorarily, run this procedure, then fix the system time ??? (dumb)</p>
  
  <pre><code>BEGIN
    DBMS_AUDIT_MGMT.CREATE_PURGE_JOB(
      AUDIT_TRAIL_TYPE           =&gt; DBMS_AUDIT_MGMT.AUDIT_TRAIL_AUD_STD,
      AUDIT_TRAIL_PURGE_INTERVAL =&gt; 24 * 30 /* hours */,
      AUDIT_TRAIL_PURGE_NAME     =&gt; 'Daily_Audit_Purge_Job',
      USE_LAST_ARCH_TIMESTAMP    =&gt; TRUE
    );
  END;
  </code></pre>
  
  <p>Is there another way I am missing ?</p>
  
  <p>It does not appear to have a start_date parameter such as DBMS_SCHEDULER.CREATE_JOB where you can specify a time.</p>