Dead job still in USER_SCHEDULER_RUNNING_JOBS
798187Sep 16 2010 — edited Mar 8 2012Hello,
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 ?