I have a distributed network that fails occassionally. When it fails, the running job transaction session cannot be killed. DBMS_job.remove or .broken does not help. Does any one have a script that can unlock any job queue lock or terminate the session without doing shutdown abort? Trying to kill the session doesn't produce the desired effect.
This is an AIX box and 8.1.6 product.

Oisaya