SELECT OWNER, JOB_NAME, ENABLED FROM DBA_SCHEDULER_JOBS; SELECT 'EXEC dbms_scheduler.disable (''' || owner || '.' || job_name || ''');' FROM dba_scheduler_jobs WHERE enabled = 'TRUE' ORDER BY owner, job_name;