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: Matthias Rogel <rogelREMOVE_at_THISweb.de>
Date: Wed, 12 Feb 2003 08:05:11 +0100
Message-ID: <b2crn7$1bgc0l$1@ID-86071.news.dfncis.de>


hi jens

Jens Toft wrote:
> 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.

how do you usually drop a table ?

matthias

>
> /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 Wed Feb 12 2003 - 01:05:11 CST

Original text of this message

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