I thought I had a whole post with the ‘how to’ find the running jobs (i.e. queries for dba_jobs & dba_jobs_running) and thus the one that has been going on endlessly…and then how to get rid of it (set to broken, join the sid from dba_jobs_running to the sid from v$session to get the info to kill the job..and then kill the OS process if needed).
But …I either dreamed I wrote this all out on a post, or I didn’t save it, or aliens at the post. Thus when attempting to fix a runaway job today, I ended up coming across this post on the subject. And, since he wrote the process out quite lovely, I reckon I shan’t waste any time rewriting it…
Leave a comment