RE: what happens if a remove a job that is running?

Yes. If you really want to kill the job, the graceful way is to break it first (dbms_job.broken) and then remove it (dbms_job.remove).

Scott Shafer
San Antonio, TX
210.581.6217

> -----Original Message-----
> From: rgaffuri_at_cox.net [SMTP:rgaffuri_at_cox.net]
> Sent: Thursday, August 14, 2003 10:00 AM
> To: Multiple recipients of list ORACLE-L
> Subject: what happens if a remove a job that is running?
>
> If I run dbms_job.remove on a job that is in dba_jobs_running it remains
> in that table.
>
> it runs to completion correct?
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: <rgaffuri_at_cox.net
> INET: rgaffuri_at_cox.net
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: Scott.Shafer_at_dcpds.cpms.osd.mil

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).