Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: DBMS_JOB.remove afterquestion

Re: DBMS_JOB.remove afterquestion

From: FC <flavio_at_tin.it>
Date: Tue, 11 Feb 2003 13:23:12 GMT
Message-ID: <4P62a.220811$AA2.8653151@news2.tin.it>


There are no docs for 8i, but the package is there. Bye,
Flavio

"Jan Gelbrich" <j_gelbrich_at_westfalen-blatt.de> wrote in message news:b2at7h$1amtvd$1_at_ID-152732.news.dfncis.de...
> Hi !
>
> DBMS_IJOB ... available only in 9i ? I found no information about it in 8i
> docs.
> BTW: is it used with the same statements as DBMS_JOB ?
>
> tia
> Jan
>
>
> "Steve Ashmore" <sashmore_at_neonramp.com> schrieb im Newsbeitrag
> news:v4ho6d23i1pd72_at_corp.supernews.com...
> > Yes dbms_ijob.remove will do it.
> >
> > There is no public synonym on it so either run it as sys or prefix it
with
> > sys.
> > or create a synonym.
>
> > > > Hello,
> > > >
> > > > Am I able (as an DBA) to remove any user's job from the queue
> (dba_jobs)
> > > ??
> > > >
> > > > M.
> > >
> > > No, you cannot.
> > > But I am told there is a workaround using a "hidden" package, called
> > > DBMS_IJOB.
> > > I never used it myself, so my advice ends here...sorry!
> > >
> > > Bye,
> > > Flavio
>
>
>
Received on Tue Feb 11 2003 - 07:23:12 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US