Path: news.easynews.com!easynews!news-out.visi.com!hermes.visi.com!news.tele.dk!small.news.tele.dk!130.133.1.3!fu-berlin.de!uni-berlin.de!207.140.171.199!not-for-mail From: "Chuck" Newsgroups: comp.databases.oracle.server Subject: Re: DBMS_JOB won't go away Date: Wed, 12 Dec 2001 15:21:18 -0500 Lines: 33 Message-ID: <9v8e5n$doccr$1@ID-85580.news.dfncis.de> References: <9v803b$cvsa6$1@ID-85580.news.dfncis.de> <3C1790F8.5050409@protek.ru> NNTP-Posting-Host: 207.140.171.199 X-Trace: fu-berlin.de 1008188408 14430619 207.140.171.199 (16 [85580]) X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Xref: easynews comp.databases.oracle.server:127972 X-Received-Date: Wed, 12 Dec 2001 13:20:13 MST (news.easynews.com) -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 "Ushkalo Igor" wrote in message news:3C1790F8.5050409@protek.ru... > 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 > Yes I am the owner of the job. -----BEGIN PGP SIGNATURE----- Version: PGPfreeware 7.0.3 for non-commercial use iQA/AwUBPBe8O2m5A4kkb4ZsEQLIVwCgnjl2TD7GGk7MhEFr87r68WstXQcAoLlP xInHltZ9ArU6mpzPMVO2r7tn =a9jL -----END PGP SIGNATURE-----