|
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 /
|
Bookmark
