RE: Terminate a dba_jobs job that is running
- From: "Terrian, Thomas J Mr CTR DLA J6DIB" <Tom.Terrian.ctr@xxxxxxx>
- To: <JBECKSTROM@xxxxxxxxx>, "oracle-l-freelists" <oracle-l@xxxxxxxxxxxxx>, "oracle-db-l" <oracle-db-l@xxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 1 Dec 2008 13:23:14 -0500
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
