RE: Terminate a dba_jobs job that is running

From: Terrian, Thomas J Mr CTR DLA J6DIB <>
Date: Mon, 1 Dec 2008 13:23:14 -0500
Message-ID: <B538F62DA0448741B308EA69417CC3020936B0@COL1SMX19.USE.AD.DLA.MIL>

Do it in two steps:

  1. Exec dbms_job.broken(<jobnumber>,true);
  2. Kill the j00 process at the O/S level.


-----Original Message-----
[] On Behalf Of Jeffrey Beckstrom Sent: Monday, December 01, 2008 1:11 PM
To: oracle-l-freelists; oracle-db-l
Subject: Terminate a dba_jobs job that is running

How can I terminate and stop from rerunning a job running in dba_jobs in 10g.    

Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority 1240 W. 6th Street
Cleveland, Ohio 44113

Received on Mon Dec 01 2008 - 12:23:14 CST

Original text of this message