Re: Kill dbms_job if I dont know number's of job!!!
From: francot <f.noreply_at_nomail.com>
Date: Mon, 7 Jan 2002 11:08:10 +0100
Message-ID: <a1brtv$p6m$1_at_atlantis.cu.mi.it>
Date: Mon, 7 Jan 2002 11:08:10 +0100
Message-ID: <a1brtv$p6m$1_at_atlantis.cu.mi.it>
"Mariusz" <mgerhant_at_wp.pl> ha scritto nel messaggio
news:a1bm0r$msd$1_at_news.tpi.pl...
> Hi,
> Id' like to kill all job on my server but I dont know number's of job!!!
> How can I do that?!!!
> Thanks
> Mariusz
>
>
>
SELECT job, next_date, next_sec, failures, broken,what from user_jobs order by next_date; Received on Mon Jan 07 2002 - 11:08:10 CET