Re: HOW TO KILL ALL DBMS.JOB?!!!

From: Brian Tkatch <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK>
Date: Fri, 04 Jan 2002 17:13:10 GMT
Message-ID: <3c35e202.3984267890@news.alt.net>

On Fri, 4 Jan 2002 15:28:27 +0100, "Mariusz" <mgerhant_at_wp.pl> wrote:

>Hi,
>Id' like to kill all job on my server!
>How can I do that?!!!
>Thanks
>Mariusz
>
>
>
>

When you say kill it, do you mean killthe current job, but leave the job to run again, or do you mean that you want to remove the job from the queue?

To remove a job from the queue, you would use the REMOVE procedure of the DBMS_JOB package. This should be in your documention, specifically, in the "Oracle8i Supplied PL/SQL Packages Reference".

For the 8.1.6/7 manual online, you'll need to log in, but here is a link.
<URL:http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/appdev.817/a76936/dbms_jo2.htm#1001062>

Brian Received on Fri Jan 04 2002 - 11:13:10 CST