Re: killing a job

From: Gerrit-Jan Linker <gjlinker_at_litconsulting.freeserve.co.uk>
Date: Thu, 25 Mar 1999 17:35:01 -0000
Message-ID: <7dedhu$l5$1@news8.svr.pol.co.uk>

Hi,

To kill a running pl/sql job do the following.

Find the sid of the running job. There is a view with all details of running jobs including the sid. Try select * from all_objects where object_name like '%JOB%' and you'll find it.

Find the other session parameters from v$session and kill the job by alter system kill session with the appropriate parameters.

Remove the job using dbms_job.remove(jobnumber). Issue a commit !

Now pray for the rollback not to take too long and for Oracle to tidy-up. This sometimes does take a long time (half an hour).

Regards, Gerrit-Jan Linker
Developer of Oraxcel, OraWeb, OraSQL and OraCodes http://members.aol.com/gjlinker Received on Thu Mar 25 1999 - 11:35:01 CST