Re: UI to the Oracle Scheduler
- From: Robert Freeman <robertgfreeman@xxxxxxxxx>
- To: Louis.Brouillette@xxxxxxx, Howard Latham <howard.latham@xxxxxxxxx>
- Date: Tue, 19 Jan 2010 07:21:37 -0800 (PST)
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.
RF
Robert G. Freeman
Oracle ACE
Ask me about on-site Oracle Training! RMAN, DBA, Tuning, you name it!
Author:
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
Blog: http://robertgfreeman.blogspot.com
Check out my new blog series on installing Oracle Database 11gR2 on Windows
using VMWare!
________________________________
From: Louis BROUILLETTE <Louis.Brouillette@xxxxxxx>
To: Howard Latham <howard.latham@xxxxxxxxx>
Cc: oracle-l@xxxxxxxxxxxxx
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
> <<mailto:Louis.Brouillette@xxxxxxx>Louis.Brouillette@xxxxxxx> 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
Email: brouille@xxxxxxx
--
//www.freelists.org/webpage/oracle-l
Other related posts:
