Was stuck with a problem where I had to delay the running of dba schedular jobs without changing
the state of the jobs. A simple solution for that was to reduce the job queue processes.
Alter system
set job_queue_processes = 0;
I promise none of your jobs will be picked up :), of-course u need dba priv's to do this.
Subscribe to:
Post Comments (Atom)
1 comment:
To see the current value set, use the query
select * from v$parameter where name='job_queue_processes';
Post a Comment