We are Oracle 12.1.0 (yes, out of support, with upgrade happening shortly)
We have series of scheduled jobs from dbms_job (yes, need to convert to dbms_scheduler)
We need to pause these jobs for day or two, to perform some transformation work. What is best way to pause these dbms_job jobs?
One suggestion I have seen is to set job_queue_processes to 0. Then restore after
Advice appreciated.