[20191104]禁止job以及SCHEDULER执行.txt
--//有时候维护需要需要停止job以及一些系统触发器,加入如下:
*._system_trig_enabled=false
*.job_queue_processes=0
SYS@test> @ hide _system_trig_enabled
NAME DESCRIPTION DEFAULT_VALUE SESSION_VALUE SYSTEM_VALUE
-------------------- --------------------------- ------------- ------------- ------------
_system_trig_enabled are system triggers enabled TRUE TRUE TRUE
alter system set job_queue_processes=0;
alter system set "_system_trig_enabled"=false;
--//但是对于使用dbms_scheduler无效,执行如下:
dbms_scheduler.set_scheduler_attribute('SCHEDULER_DISABLED','TRUE');
--//还原如下:
alter system set job_queue_processes=1000;
alter system reset "_system_trig_enabled";
dbms_scheduler.set_scheduler_attribute('SCHEDULER_DISABLED','FALSE');