Path: news.easynews.com!easynews!news-out.cwix.com!newsfeed.cwix.com!newsfeed.sovam.com!sovam!not-for-mail
From: Ushkalo Igor <igorus@protek.ru>
Newsgroups: comp.databases.oracle.server
Subject: Re: DBMS_JOB won't go away
Date: Wed, 12 Dec 2001 20:16:40 +0300
Organization: Protek
Lines: 14
Message-ID: <3C1790F8.5050409@protek.ru>
References: <9v803b$cvsa6$1@ID-85580.news.dfncis.de>
NNTP-Posting-Host: 194.154.72.10
Mime-Version: 1.0
Content-Type: text/plain; charset=KOI8-R; format=flowed
Content-Transfer-Encoding: 7bit
X-Trace: news.sovam.com 1008177357 19513 194.154.72.10 (12 Dec 2001 17:15:57 GMT)
X-Complaints-To: abuse@online.ru
NNTP-Posting-Date: Wed, 12 Dec 2001 17:15:57 +0000 (UTC)
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:0.9.4) Gecko/20011128 Netscape6/6.2.1
X-Accept-Language: ru,en
Xref: easynews comp.databases.oracle.server:127969
X-Received-Date: Wed, 12 Dec 2001 10:50:07 MST (news.easynews.com)

Chuck wrote:

> I have a job showing up in DBA_JOBS_RUNNING that doesn't show up in
> DBA_JOBS. I tried to remove it with DBMS_JOB.REMOVE but that failed.
> I tried to use DBMS_IJOB.REMOVE and that ran succesfully but the jobs
> is still showing up with most of the columns containing NULL even
> after I did a COMMIT. Here's what DBA_JOBS_RUNNING looks like...

Check are you the owner of these jobs?
Only owner of job can remove it.

-- Best regards, Igor Ushkalo (igorus!) - igorus(at)mail.ru,
    ICQ #19972198