Re: DBMS_JOB
From: Michel Cadot <micadot_at_netcourrier.com>
Date: Tue, 15 May 2001 09:57:48 +0200
Message-ID: <9dqnhu$vg7$1_at_s1.read.news.oleane.net>
Date: Tue, 15 May 2001 09:57:48 +0200
Message-ID: <9dqnhu$vg7$1_at_s1.read.news.oleane.net>
<NeedaHoliday> a écrit dans le message news: uid0gtci7n7ghejhi0lovgqs4a9pac0okt_at_4ax.com...
> Could someone please tell me why Oracle hasn't come up with a way to
> abort executing job that were submitted through DBMS_OUTPUT.SUBMIT.
>
I think you meant dbms_JOB.submit.
You can use dbms_job.remove to remove the job from the job queue
or dbms_job.broken to prevent the job from running.
-- Regards MichelReceived on Tue May 15 2001 - 09:57:48 CEST