Re: DBMS_JOB.remove

From: Steve Ashmore <sashmore_at_neonramp.com>
Date: Tue, 11 Feb 2003 05:38:56 -0600
Message-ID: <v4ho6d23i1pd72@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
>
>
Received on Tue Feb 11 2003 - 05:38:56 CST