How to permanently kill a DBMS_JOB
... prior to that 16 failures.
I have two jobs that I want to permanently kill.
I have set them to BROKEN.
I have set job_queue_processes = 0;
I have killed off all sessions related to these jobs.
As soon as I reset job_queue_processes back > 0 (to 10), the old processes restart (with their old session id's) and then the job is set to UNbroken!
How do I totally get rid of these jobs, withot having to wait out the 16 failures .
Also, do DBMS_SCHEDULER jobs follow this same 16x failure behavior if the job fails ?
These re unexpected failures due ot resource problems - it is NOT ok to just let them run, they will hang the system (again) and fail gain.
Thank you,
Karen