Code Listing 7: Scheduling recompile_invalid_objects to run every 30 minutes

 1  BEGIN
 2     DBMS_SCHEDULER.CREATE_JOB (
 3        job_name             => 'scott.recompile_invalid_objects;'
 4      , repeat_interval      =>  'SYSTIMESTAMP + INTERVAL '30' MINUTE'
 5      , comments             => 'Auto-recompile of code base');
 6  END;
7 /