Chapter 17Scheduling Tasks
Scheduling tasks for automated execution can save you time, and your company money. Examples of these tasks include the regular collection of statistics, the purging of interface tables at a specific time, or the execution of any anonymous PL/SQL block, shell script, or stored procedure. Virtually any program or executable can be scheduled for execution using the built-in packages DBMS_JOB and, in Oracle 10g, DBMS_SCHEDULER.
Alas, DBMS_JOB's time is almost up. With Oracle 10g comes DBMS_SCHEDULER, a built-in package that is available from the command line and is fully integrated with the Enterprise Manager utility. While offering all the functionality of DBMS_JOB, it also provides some great new features not available ...
Get Oracle Database 10g PL/SQL Programming now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
