Re: DBMS_JOB.remove afterquestion

"FC" <flavio_at_tin.it> wrote in message
news:4P62a.220811$AA2.8653151_at_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
> >
> >
> >
>
>

I'm interested in this. All the documention (pre 9i I confess) that I've read so far says that only owners can do things with their own jobs.

If this is changing (analogous, it seems to me, to the 9i option of being able to issue initial object grants as other than the owner of the object), then IMHO this is another welcome step forward in flexibility.

Regards,
Paul Received on Tue Feb 11 2003 - 14:54:28 CST