I finally figured out how to kill the process that was scheduled in
dba_jobs. You have to break the job first or else Oracle will restart
the job trying to complete it. So I sat their killing processes over
and over until I read up on DBMS_JOB.
Here's more detail:
-- Mark the job that called the process broken.
exec dbms_job.broken(job => 359, broken => TRUE);
-- kill the process.
-- Ok so you could alter system kill session but I'm really wanting
-- to kill this.
host kill -9 11345
-- Mark the job as nolonger broken so it will run again at its regularly
-- scheduled time.
exec dbms_job.broken(job => 359, broken => FALSE, next_date =>
to_Date(to_char(trunc(sysdate+1) , 'DD-MON-YYYY') || ' 02:00:00', 'DD-MON-YYYY
HH24:MI:SS'));
Dave
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: David Turner
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).