views:

262

answers:

1

Hi all, I am looking for a scheduler framework which can provide the following functionality -

1. Audit of the processes - start time, end time and throughput of the process
2. Balance - if necessary schedule jobs according to the load
3. Control - when to run a job? like cron of Unix, helps us to schedule processes at the specified time intervals.

If we look into a datawarehouse type of application - lets say I want to monitor the ETL processes. When the extraction finishes, loading should start. Loading should not take more than 15 mins - if it is taking then log an audit message etc etc.. I am sure there must be some already framework in place which helps to orchestrate the whole software system - when to run which processes ? what are their dependencies ? How to log the throughput of the process etc..

A: 

If you are already in an oracle environment using dbms_scheduler would be the answer. It has all functionality that you ask for plus more. Load balancing is built into the database, resource manager handles that and is fully integrated with the Oracle Scheduler.

You can define a job to generate an event when it runs longer than expected. A monitoring process can pick that event from the scheduler event Q and react upon it anyway you like to.

there is a nice book written on the subject that explains how to get the most out of it

best regards, Ronald

ik_zelf