To turn the scheduler off use
exec dbms_scheduler.set_scheduler_attribute('SCHEDULER_DISABLED', 'TRUE')
Note that the TRUE is not a BOOLEAN but text.
To check the status
select * from DBA_SCHEDULER_GLOBAL_ATTRIBUTE;
To turn the scheduler back on again
exec dbms_scheduler.set_scheduler_attribute('SCHEDULER_DISABLED', 'FALSE')
thanks, you are a star
ReplyDeletethanks it helped .
ReplyDelete