Re: DBMS_JOB won't go away

From: Chuck <chuck_hamilton_at_yahoo.com>
Date: Wed, 12 Dec 2001 15:21:18 -0500
Message-ID: <9v8e5n$doccr$1@ID-85580.news.dfncis.de>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

"Ushkalo Igor" <igorus_at_protek.ru> wrote in message news:3C1790F8.5050409_at_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 <http://www.pgp.com>

iQA/AwUBPBe8O2m5A4kkb4ZsEQLIVwCgnjl2TD7GGk7MhEFr87r68WstXQcAoLlP xInHltZ9ArU6mpzPMVO2r7tn
=a9jL
-----END PGP SIGNATURE----- Received on Wed Dec 12 2001 - 14:21:18 CST