Re: user jobs in Database Control 10g

From: <>
Date: Tue, 23 Sep 2008 23:40:35 +0200
Message-ID: <>

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.
>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.

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.

Sybrand Bakker
Senior Oracle DBA
Received on Tue Sep 23 2008 - 16:40:35 CDT

Original text of this message