DBMS_JOB won't go away

From: Chuck <chuck_hamilton_at_yahoo.com>
Date: Wed, 12 Dec 2001 11:20:59 -0500
Message-ID: <9v803b$cvsa6$1@ID-85580.news.dfncis.de>

-----BEGIN PGP SIGNED MESSAGE-----

Hash: SHA1

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...

SQL> select job from dba_jobs
2 /

JOB
- ----------

SQL> select * from dba_jobs_running
2 /

SID JOB FAILURES LAST_DATE LAST_SEC THIS_DATE THIS_SEC INSTANCE
- ---------- ---------- ---------- --------- -------- --------- - -------- ----------

7 14464

-----BEGIN PGP SIGNATURE-----

Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>

iQA/AwUBPBeD42m5A4kkb4ZsEQJECACfX+VfyZlheL9jWFW/WMunz7ICYb4AoIhM qwUFB6qtciOUGfnbRUFgbiba
=B8Be
-----END PGP SIGNATURE-----
Received on Wed Dec 12 2001 - 10:20:59 CST