Re: user jobs in Database Control 10g

From: Palooka <>
Date: Tue, 23 Sep 2008 23:17:05 +0100
Message-ID: <uVdCk.108642$Tk5.29073@newsfe13.ams2> wrote:
> On Tue, 23 Sep 2008 22:03:47 +0100, Palooka <>
> wrote:

>> sybrandb wrote:
>>> On 23 sep, 08:59, "timo" <> wrote:
>>>> Hi,
>>>> In our Db there are some schema users with jobs submitted.
>>>> Problem is that I cannot find those jobs in Database Control (10g)...
>>>> (In TOAD etc there's no problems)
>>>> BR,
>>>> Timo
>>> You can not find them using Database Control because Oracle introduced
>>> a new mechanism to schedule jobs, called dbms_scheduler.
>>> Database Control exclusively oversees dbms_scheduler jobs, the jobs
>>> submitted through dbms_jobs are ignored.
>>> There is way more functionality in the scheduler (the scheduler also
>>> deals with O/S jobs, so it replaces cron and/or the Scheduled Tasks
>>> applet in Windows Control Panel), so you could consider upgrading.
>>> You would need to monitor the 'old-style' jobs in Database Control by
>>> submitting SQL.
>> Sybrand,
>> PMFJI. No argument with anything you say, but (assuming that the 
>> iSQL*Plus link is not available), how does one submit SQL in OEM 
>> Database Control? Are you referring to the extensibility stuff in 
>> document B16246-02, or to something else?
>> I am asking in the context of with OEM Database Control.
>> Thanks,
>> Palooka

> I was assuming Isqlplus is available (in my case it is), though I note
> it is possible (I am using Grid Control) on the jobs tab, or at the
> Jobs link on the database tab, to submit a SQL job.
> I didn't try that yet though.

Thanks, Sybrand.

Unfortunately iSQL*Plus is probably not going to be allowed in our environment - the client doesn't like it. I have made it available for now, but will probably have to stop the service, even in pre-production environments.

I note with some sadness that iSQL*Plus is likely to be dropped from some future Oracle version. Disappointing, that.

Thanks, anyway.
Palooka Received on Tue Sep 23 2008 - 17:17:05 CDT

Original text of this message