Oracle Job Scheduling - ORSYP

Oracle job scheduling refers to the act of submitting batch tasks to run on Oracle databases and possibly within Oracle E-business suite, on the required day, at the right time, in the required order and in the right circumstances. Oracle job scheduling is most often applied to recurrent data processing tasks that may be of either a business or a technical nature.

Oracle databases provide built in PL/SQL packages called DBMS_JOB (or DBMS_ SCHEDULER depending on version) to schedule batch processes within an Oracle database. These tools address the needs of an Oracle DBA, provide basic time/date based scheduling functions and need a lot of development to satisfy more sophisticated requirements.

Oracle E-Business Suite provides Concurrent Managers to schedule jobs and request sets. Concurrent Managers inherit the functional limitations of the DBMS_ SCHEDULER package, “fire and forget”, no business calendars, limited to internal tasks, rudimentary monitoring etc.

Advanced Oracle job scheduling provides sophisticated date and time based scheduling, integrating notions of working days and holidays. Advanced Oracle job scheduling will integrate tightly to Oracle E-Business Suite interfacing with the Internal Concurrent Manager to submit jobs and request sets, pass the required parameters, recuperate the completion status and the processing log.

Advanced Oracle job scheduling additionally provides cross-platform, cross-application workflows, inter-job dependencies, dependencies on resources, business or technical events to facilitate the automation of straight through business processes across packaged Applications like Oracle E-Business Suite, SAP, PeopleSoft etc, home grown applications using Oracle or any other database platform.