Re: user jobs in Database Control 10g

From: Palooka <>
Date: Tue, 23 Sep 2008 22:03:47 +0100
Message-ID: <MQcCk.37149$a01.20268@newsfe15.ams2>

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.


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.

Palooka Received on Tue Sep 23 2008 - 16:03:47 CDT

Original text of this message