Use Oracle 10g's DBMS_SCHEDULER to control batch job resources

Friday Apr 13th 2007 by Staff

Unlike the older DBMS_JOB package, DBMS_SCHEDULER in Oracle 10g is integrated with Resource Manager to give you precise control over the resources consumed by batch jobs.


Oracle 10g introduced a replacement for the venerable DBMS_JOB package. DBMS_SCHEDULER has many benefits over DBMS_JOB, such as easier specification of start and interval times, and the ability to schedule operating system executables as well as PL/SQL. One of the best new features in DBMS_SCHEDULER is its tight integration with Resource Manager.

The article continues at

Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved