Hi. I'm Colin Greenwood.

I have developed two related software products. The first is called SchedulerLite and it is designed for use on Oracle Database 10g and above. If you are familiar with the Oracle database then you will be aware that the Oracle database incorporates a scheduling system. Prior to Oracle 10g this scheduling process had limited functionality. With Oracle 10g this totally changed and a totally new and sophisticated tool was incorporated.

SchedulerLite is a tool that displays the details of the Jobs that are expected to run on any selected date. It also displays the Job logs, displaying the details of the Jobs that have already ran. These are two separate displays and are designed to allow the DBA to see what has run in the past and what is expected to run in the future. This tool will help the DBA to act proactively to prevent problems arising. To find out more about this tool the following document, SchedulerLite - User Documentation, has been provided.

To download the SchedulerLite program, click on the following:- SchedulerLite.jar

On my version of Internet Explorer, Version 7, the download file, SchedulerLite.jar gets renamed to SchedulerLite.zip. If this occurs with yourself rename to SchedulerLite.jar after it has been downloaded.

Scheduler FE is also a tool built for Oracle's Scheduler module. The new tool, Scheduler FE, where FE stands for Front End, is designed to allow the Scheduling Manager to gain access to the information he/she needs from the Scheduling system. It offers a set of screens that enable the properties of the scheduling system to be seen easily. It allows the user to move easily from one area to another so that he/she can quickly obtain the information required.

Scheduler FE allows the underlying objects to be seen as a whole. It shows the relationships between them in a graphical tree structure and then by highlighting the specific object the user can see the values that have been assigned to it.

In addition to the production version there is a prototype version that runs on a MySQL database. The system runs from Java Web Start and by creating the Oracle DBA views on the MySQL database you the user community can see and trial the Scheduler FE system. When the opening screen appears you will need to click on the "Connect" button and then enter the username/password/hostname shown below. The prototype is not an exact replica of the production version and does not update the underlying tables.

There are three usernames to choose from on the prototype. The first username, web172-james has the equivalent of DBA role assigned to the username. It gives access to all information and allows the deletion, creation and update of all objects. The second username, n-web172-david, is the equivalent of Support manager with access to view all information except the global attributes section but no permissions to create update or delete objects. He/she does have permission to run/stop jobs and to enable/disable jobs. The third username, n-web172-janet, has the equivalent of user role. He/she has access rights to see the currently running jobs, the jobs log and the job/schedules/programs that exist in the system. They is no permissions to change the objects in any way.

Try it for yourself. Run the prototype.

·          Run Schedule FE for Oracle 10g Release 2

You will need the username/password/hostname given in the table below to log on to the database.

Read the full details of Scheduler FE system - Schedule FE - User Documentation

Download Scheduler FE -

After downloading, extract the two files, Scheduler.jar and SchedFileData.csv and put them in a directory together. Click on Scheduler.jar to run the Scheduler FE.

Having downloaded and tried out the system. I hope you will continue to use it. If you do then send me an e-mail. By registering yourself as a user I will be able to update you when the system is upgraded.

In addition to e-mailing me to register you might wish to add any constructive comments so that I can continuously improve the product.

You can contact me, Colin Greenwood, at the following email address:- colin@enghan.demon.co.uk

Further Documentation :-