Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DBMS_JOB.remove
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. >> >>