Re: DBMS_JOB

NeedaHoliday wrote:
>
> Could someone please tell me why Oracle hasn't come up with a way to
> abort executing job that were submitted through DBMS_OUTPUT.SUBMIT.
>
> James.stewart_at_nospamPWGSC.GC.CA
>
> Omit nospam to email

Kill the SNPn process (or if you're on NT - use orakill.exe on the server).
Hit the job where it lives.

D:\Oracle\Ora81\BIN>orakill

Usage: orakill sid thread

  where sid = the Oracle instance to target

        thread = the thread id of the thread to kill

  The thread id should be retrieved from the spid column of a query such as:

        select spid, osuser, s.program from
        v$process p, v$session s where p.addr=s.paddr

hth,

Paul Received on Thu May 17 2001 - 06:19:50 CEST