Skip to Main Content

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!

Can't stop a job execution

504506Jun 3 2006 — edited Jun 14 2012
I 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 12 2012
Added on Jun 3 2006
6 comments
10,166 views