Oracle Scheduler - ORSYP

Dollar Universe, the Oracle Scheduler for Oracle E-Business Suite

An Oracle scheduler submits 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. An Oracle scheduler is most often applied to recurrent data processing tasks 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 focus on the needs of an Oracle DBA, provide basic time/date based scheduling functions; they 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.

The advanced Oracle scheduler provides sophisticated date and time based scheduling, integrating notions of working calendars and holidays. This advanced Oracle scheduler will integrate tightly with 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.

The advanced Oracle scheduler 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, and more, including home grown applications using Oracle or any other database platform.