Re: user jobs in Database Control 10g
Date: Tue, 23 Sep 2008 23:17:05 +0100
> On Tue, 23 Sep 2008 22:03:47 +0100, Palooka <nobody_at_nowhere.com>
>> sybrandb wrote: >>> On 23 sep, 08:59, "timo" <timo.ta..._at_luukku.com> 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 10.2.0.4 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.
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.
Palooka Received on Tue Sep 23 2008 - 17:17:05 CDT