DBMS_JOB

From: David Turner <turner_at_tellme.com>
Date: Wed, 05 Sep 2001 21:16:00 -0700
Message-ID: <F001.0038480D.20010905211933@fatcity.com>

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: turner_at_tellme.com

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: ListGuru_at_fatcity.com (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). Received on Wed Sep 05 2001 - 23:16:00 CDT