Re: UI to the Oracle Scheduler

From: Robert Freeman <>
Date: Tue, 19 Jan 2010 07:21:37 -0800 (PST)
Message-ID: <>

We have been dealing with this question for a while now without an easy answer. OEM/Grid Control is one answer already given here. Another is that you could write a fairly simple interface with APEX. Are you locked into using the Oracle scheduler? If not, there are centralized scheduling packages out there that you could use instead.


 Robert G. Freeman
Oracle ACE
Ask me about on-site Oracle Training! RMAN, DBA, Tuning, you name it!
Oracle Database 11g RMAN Backup and Recovery (Oracle Press) - ON ITS WAY SOON!
OCP: Oracle Database 11g Administrator Certified Professional Study Guide (Sybex)
Oracle Database 11g New Features (Oracle Press)
Oracle Database 10g New Features (Oracle Press)
Other various titles
Check out my new blog series on installing Oracle Database 11gR2 on Windows using VMWare!

From: Louis BROUILLETTE <>
To: Howard Latham <>
Sent: Tue, January 19, 2010 8:12:31 AM
Subject: Re: UI to the Oracle Scheduler

We control what's in the job.  They only schedule it, they don't create a job.  They are the ones who decide when to run these jobs.

At 09:45 2010-01-19, Howard Latham wrote:
> You want users to schedule jobs? are they technical? Do they write the code?  You are scaring me!
> On 19 January 2010 14:27, Louis BROUILLETTE <<>> wrote:
> We have lots of batch jobs (in an old application) that we would like to rewrite in PL/SQL.  These jobs have to be scheduled by end users.  The Oracle Scheduler (from 10g) has all the features needed except for the user interface (unless it's there but didn't see it).  We need a really simple one (on the web) that end users can use to schedule jobs (one-time job, recurrent job, etc).
> Has anyone ever seen anything like that ?  I guess we're not the only ones who want their users to be able to schedule their jobs by themseves.

> Howard A. Latham

Louis Brouillette
Chargé de projet informatique et technologique (DBA)
Université du Québec à Trois-Rivières
Tel: (819) 376-5011 ext. 2435
Received on Tue Jan 19 2010 - 09:21:37 CST

Original text of this message