Re: user jobs in Database Control 10g

On Sep 23, 3:17 pm, Palooka <nob..._at_nowhere.com> wrote:
> sybra..._at_hccnet.nl wrote:
> > On Tue, 23 Sep 2008 22:03:47 +0100, Palooka <nob..._at_nowhere.com>
> > wrote:
>
> >> 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.
>
> 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

From dbcontrol home page, scroll down, click on jobs link, drop down menu next to Create Job has a sql script selection. If I'm understanding the question correctly.

jg

--
@home.com is bogus.
 “The greatest player in the world is sitting at home watching and
texting me, and everybody else he can find. He texted 10 times
(Saturday), at least.”   – U.S. Ryder Cup captain Paul Azinger on
Tiger Woods recovering from knee surgery