Oracle Built−in Packages- P123: Ah, for the good old days of Version of PL /SQL! Life was so simple then. No stored procedures or functions and certainly no packages. You had your set of built−in functions, like SUBSTR and TO_DATE. You had the IF statement and various kinds of loops. With these tools at hand, you built your batch−processing scripts for execution in SQL*Plus, and you coded your triggers in SQL*Forms , and you went home at night content with a good day's work done. | Appendix A What s on the Companion Disk jobno smart_job 180 NO_RESTART next_date broken job SYSDATE 1 1440 SYSDATE 1 COMMIT WORK END print jobno BEGIN Test the ability to break itself. 99 smart_job 180 RESTART next_date broken job SYSDATE 1 1440 SYSDATE 1 COMMIT WORK END After executing the test script in SQL Plus the following jobs are in the queue SQL SELECT job last_date next_date broken FROM user_jobs JOB LAST_DATE NEXT_DATE B 307 1ü 11 ü 11 50 ü N 308 1997 11 25 11 50 39 N 99 1997 11 25 11 50 40 N A few minutes later the job queue looks like this SQL SELECT job last_date next_date broken FROM user_jobs JOB LAST DATE NEXT DATE B 307 1997 11 25 11 50 42 1997 11 25 14 50 42 N 99 1997 11 25 11 50 42 1997 11 26 11 50 42 Y The tests worked Job 308 ran once and was removed from the queue for having a NULL next_date. Job 307 ran and rescheduled itself three hours later which is different from the interval specified in the call to . Finally job 99 set itself to broken status because its job number was less than 100. PREVIOUS HOME HEXT Tips on Using B0CK INDEX IV. Distributed Database DBMS_JOB Packages I. Orode PL SQL Orode PL SQL Orode Advanced PL SQL Oracle Wefe Applications Oracle PL SQL Oracle PL SQL H Programming I Programming I Budt-in I Programming I PL SQL Developer s I Language I Budt-ins 0 ne Second Edition Guide to Orade8r features Packages with Packages Introduction Pocket Reference Pocket Reference Copyright c 2000 O Reilly Associates. All rights reserved. Self-Modifying and Self-Aware Jobs 601 Oracle Built-in Packages SEARCH PREVIOUS Chapter 14 NEXT 602 14. Snapshots Contents DBMS_SNAPSHOT Managing Snapshots DBMS_REFRESH Managing Snapshot Groups DBMS_OFFLINE_SNAPSHOT Performing Offline Snapshot Instantiation DBMS_REPCAT Managing Snapshot Replication Groups Oracle provides a number of packages that let you perform various types of administrative operations on snapshots and snapshot logs. Most of these .