Re: DBMS_JOB.remove

"Steve Ashmore" <sashmore_at_neonramp.com> wrote in message 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.
>
> Stephen C. Ashmore
> Brainbench MVP for Oracle Administration
> http://www.brainbench.com
> Author of: 'So You Want to be an Oracle DBA?'
>
> "FC" <flavio_at_tin.it> wrote in message
> news:wF42a.164485$0v.4614444_at_news1.tin.it...
> >
> > "Marcin" <mwolski_at_poczta.fm> wrote in message
> > news:b2agk9$irm$1_at_sunflower.man.poznan.pl...
> > > 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
> >
> >

the only documentation for this is on metalink. are there many packages that are undocumented? is there a reason, why this might be undocumented, ie, might change with each release?

glad i stumbled on this. i think its useful for what im currently doing. Received on Tue Feb 11 2003 - 10:49:35 CST