Batch Scheduler

The Batch Scheduler is a set of processes and objects that are defined and executed within the ORMB framework using the objects implemented by the DBMS_​SCHEDULER package that is embedded in every installation of the Oracle Database. ORMB uses the DBMS scheduler objects to schedule Jobs/Batches in the background.

Some features of ORMB DBMS scheduler include:

  • User Interface to help define workflow and/or job dependencies

  • User Interface to submit/schedule, monitor and administration of Batch Jobs

The DBMS Scheduler supports the following scheduling methods:

  • Time based scheduling - Scheduling job based upon dates and times

  • Dependency scheduling - Scheduling based upon job dependencies using Chains

The ORMB DBMS scheduler uses the following objects:

  • Program: The lowest object in a scheduler is the Program. A program describes what is to be run by the schedule. The program object includes a definition of the physical object as well as arguments to execute them.

  • Job: An instance of a program, is a Job. The job is a collection of metadata that defines the program to execute as well as where to execute it (for remote executions), its related schedule (which dictates when it is executed) and any related information. Jobs are subject to scheduling using the time based, event based and/or dependency of other jobs.

  • Schedule: The Schedule object defines when and how many times the job is executed. The schedule object uses a rich calendaring syntax to define repeating schedules. Jobs also contain data used for prioritizing as well as resource profiles including support for Windows and Resource Manager.

  • Chains: Chains represent the sequences of jobs expressing the dependencies. Chains define steps which link a job or file watcher and also contains Rules to decide the sequence and outcomes based upon the state of another job in the chain. For example, Job B needs to run only if Job A has completed successfully. Chains can support multiple branches and also chains can include other chains for greater reuse.

Advantages of using Oracle Scheduler Interface:

  • License free implementation

  • ORMB embedded user interfaces for setting up Batch Scheduling

  • Less Administration

  • Supports High Availability

  • Maximum Flexibility

Parent Topic: Oracle Revenue Management and Billing Generic Business Processes