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: Jens Toft <toftnews_at_yahoo.ie>
Date: Tue, 11 Feb 2003 23:19:45 -0000
Message-ID: <Byf2a.9024$V6.12108@news.indigo.ie> 





Hi,



If you're brave, you can delete the job directly from the job$ table as SYS.
(delete from job$ where job=<id>). I have done so on numerous occasions with
no side effects.



/Mort



"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.

>

>

Received on Tue Feb 11 2003 - 17:19:45 CST












Original text of this message













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