Re: DBMS_JOB won't go away

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