O'Reilly logo

Oracle Database 10g PL/SQL Programming by Michael McLaughlin, Ron Hardman, Scott Urman

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required