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

Re: DBMS_JOB.remove

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Wed, 12 Feb 2003 20:12:58 -0500
Message-ID: <v4ls90d9b5hb06@corp.supernews.com>


Vladimir,
.. I is indeed Internal.
This package used to be mentioned in the Oracle 7 Distributed Systems Manual where its stated that I stands for internal..

Anurag

"Vladimir M. Zakharychev" <bob_at_dpsp-yes.com> wrote in message news:b2cs19$81u$1_at_babylon.agtel.net...
> I believe there is quite a lot of undocumented packages out there.
> Some have unwrapped (and documented in comments) specs, some
> are fully wrapped. $ORACLE_HOME/rdbms/admin is a good place
> for research. :)
> And I think the reason DBMS_IJOB is not documented is because it
> is supposed to be only used by IMP to import jobs (that 'I' can be
> either Import or Internal, but I think Import is more like it.)
>
> --
> Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
> Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
> All opinions are mine and do not necessarily go in line with those of my employer.
>
>
> "Ryan Gaffuri" <rgaffuri_at_cox.net> wrote in message
> news:1efdad5b.0302110849.71c4f911_at_posting.google.com...
> > "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 Wed Feb 12 2003 - 19:12:58 CST

Original text of this message

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