How to enable and disable ALL Jobs in ORACLE

u can use this query to disable or enable all jobs except EXFSYS,ORACLE_OCM,SYS.. u can simply chose in which owners should be not by adding user names at the end of script...

TO DISABLE

	select q'! exec dbms_scheduler.disable('!' || OWNER || '.' || JOB_NAME || q'!');!'
	from DBA_SCHEDULER_JOBS where enabled='TRUE' and owner not in ('EXFSYS','ORACLE_OCM','SYS')

view raw disable_job.sql hosted with ❤ by GitHub

TO ENABLE

	select q'! exec dbms_scheduler.disable('!' || OWNER || '.' || JOB_NAME || q'!');!'
	from DBA_SCHEDULER_JOBS where enabled='FALSE' and owner not in ('EXFSYS','ORACLE_OCM','SYS')

view raw enable.sql hosted with ❤ by GitHub

just run outputs...