Re: Terminate a dba_jobs job that is running

 EXEC DBMS_JOB.BROKEN(job#,TRUE);
ALTER SYSTEM KILL SESSION 'sid,serial#';

OR

ALTER SYSTEM SET job_queue_processes = 0; BUT: This will bring down the entire job queue processes.

On Mon, Dec 1, 2008 at 1:11 PM, Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>wrote:

> 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