Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Dead job still in USER_SCHEDULER_RUNNING_JOBS

798187Sep 16 2010 — edited Mar 8 2012

Hello,

I'm using Oracle 11gR2 on Linux and I have a problem with the scheduler:
When I query USER_SCHEDULER_RUNNING_JOBS, I have a job with no session ID and no process ID running for with an elapsed time of 5 days. Actually this job is not really running.
The problem is that I can't stop it using DBMS_SCHEDULER.STOP_JOB, I can't drop it with DBMS_SCHEDULER.DROP_JOB and the job does not run anymore because it is considered as running by the scheduler.
I also stopped and restarted the scheduler by setting the job_max_processes to 0 then back to 10 without effect on the stucked dead job.

Any idea on how I can purge this dead job ?

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 5 2012

Added on Sep 16 2010

#11g, #database-key-features, #dba, #job, #scheduler

14 comments

10,516 views