DBMS_JOB.remove afterquestion

From: Jan Gelbrich <j_gelbrich_at_westfalen-blatt.de>
Date: Tue, 11 Feb 2003 14:17:33 +0100
Message-ID: <b2at7h$1amtvd$1@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:17:33 CST