RE: Terminate a dba_jobs job that is running
Date: Mon, 1 Dec 2008 13:23:14 -0500
Do it in two steps:
- Exec dbms_job.broken(<jobnumber>,true);
- Kill the j00 process at the O/S level.
[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.
Greater Cleveland Regional Transit Authority 1240 W. 6th Street
Cleveland, Ohio 44113