Can't stop a job execution
504506Jun 3 2006 — edited Jun 14 2012I have Oracle 10g and a scheduled job which executes a hot backup every day at 2 AM.
.
Yesterday evening at 10 PM the listener hung. I rebooted the machine this morning and everything is fine now.
However, the Jobs page shows, that the last backup has been running for 15 hours now!
When I try to stop it, it says "The job was stopped successfully", but I see status is still "Running". I tried to delete it, but it says it must be stopped first.
Is there any way to kill this job?
I know there is a DBMS_SCHEDULER.STOP_JOB procedure, but it requires job name and I don't know how to get that.
I didn't find anything useful in dba_jobs or any other view.