RE: Terminate a dba_jobs job that is running

Do it in two steps:

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

Tom

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] 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

--
http://www.freelists.org/webpage/oracle-l