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

That will not kill a job which is currently executing. It simply removes it from the queue. The only way I know to kill a running job is to kill the associated job queue process on the server.

Ian MacGregor
Stanford Linear Accelerator Center
ian_at_slac.Stanford.edu

-----Original Message-----
Sent: Thursday, August 14, 2003 10:34 AM To: Multiple recipients of list ORACLE-L

Yep. That sounds like your MO :)

Henry

-----Original Message-----
Scott.Shafer_at_dcpds.cpms.osd.mil
Sent: Thursday, August 14, 2003 12:19 PM To: Multiple recipients of list ORACLE-L

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Henry Poras
  INET: hporas_at_etal.uri.edu

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: MacGregor, Ian A.
  INET: ian_at_SLAC.Stanford.EDU

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).