Chuck wrote:
>
> -----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-----
Probably best to have a call to Oracle - and also have a look in
SYS.JOB$ to see whats in there. Note: This is "have a look" in SYS.JOB$
not "have a hack" :-)
hth
connor
--
==============================
Connor McDonald
http://www.oracledba.co.uk
"Some days you're the pigeon, some days you're the statue..."
Received on Fri Dec 14 2001 - 04:07:22 CST
