a simple but effective tool to manage data warehouse loads.
DW Scheduler has been designed to ease the everyday work of scheduling, managing, editing and monitoring the daily execution of Oracle data warehouse jobs. With the use of DW Scheduler, you will be able to access all the features of the daily job management without the need of manual editing of tables with 3rd party tools (like Toad, etc) or to write special SQL queries.
DW Scheduler provides a rich and intuitive web based GUI, accessible on the companies intranet. With it's highly flexible security settings even business users can monitor, trigger or schedule their jobs. Our scheduler can replace Oracle Warehouse Builder's workflow module (WF), providing the same functionality with a friendlier and robust web interface.
It runs almost invisible, consumes only minimal resources from the data warehouse back-end database - even in case of high number of jobs scheduled, executed, monitored.
DW Scheduler uses an Oracle based repository database, so it's metadata can be accessed and used by other applications, it can be easily integrated into frameworks built around an Oracle data warehouse.
DW Scheduler is based on standard Oracle technologies: only PL/SQL codes and Application Express are used. No external applications required to access resources of Oracle DBMS - the DW Scheduler is as secure as your Oracle database deployment.
Users of DW Scheduler can enter all operating information, parameters and settings on it's Apex based web interface. Users can submit, change or delete metadata on executable procedures, functions or OWB mappings, their expected scheduling, dependencies, runtime parameters, etc.
Users can also trigger job or jobgroup executions, or can run the whole daily load-window manually.
DW Scheduler also allows the users to monitor job or jobgroup executions, search for metadata of previous job executions, provides data for reporting on DW load performance, errors, SLA-s, etc.
DW Scheduler uses basic terms to classify job management metadata : Jobgroups and Jobs.
Jobgroups are logical units, containers created for the Jobs. DW Scheduler scheduling functions operate on Jobgroup level.
The executable procedures, functions or OWB mappings are referred by DW Scheduler as Jobs, because the execution of those are managed through Oracle jobs.
The Jobs can be grouped into Jobgroups. (like all Jobs loading the sales data can belong to the DW_SALES_JOBS group, etc). The Jobs within a Jobgroup can be organized by their dependencies. The Jobgroups can also be organized based on the dependencies of Jobgroups.
If a dependency is set between two jobs, the dependent job will not get started till the preliminary job was not finished. A Jobgroup will be also executed only if its dependencies from other Jobgroups are satisfied (the other Jobgroups had been finished), and if the schedule conditions are also satisfied.
In this way you can implement different scenarios, with a combination of dependent jobgroups and/or jobs.
The following figures show some possible scenarios:
DW Scheduler execution uses a complex algorithm to calculate the optimal parallel degree of jobs for the best performance - without the danger of overloading the database server. The number of Jobs specified in parameters are launched together if those are not dependent from each other, but jobs with dependencies will start only when the preceding jobs are finished. Dependent Jobgroups will not start if any of the preceding Jobgroups are set to inactive.
The DW Scheduler creates detailed logs on Job and Jobgroup executions in it's repository. These logs can be accessed through the web interface or directly as required. If OWB jobs were scheduled, DW Scheduler can combine and merge the logs from it's own and from OWB's framework to ease the monitoring of jobs, possible errors, etc.
DW Scheduler can be used with Oracle 9i and above. Since it is a poorly Oracle hosted application, it does not require external resources (hardware or software) - and such it has no compatibility issues.
It does not require costly Oracle options - can run on any Oracle versions from XE to Enterprise.