A tester approached me today to enable job execution on a reporting database.
I knew what to do but couldn't navigate the package easily so I thought I should share... Oracle provides the dbms_scheduler package for achieving this.
Run scipt below on the oracle server to enable jobs.
To disable you can run
However, If you are you are using dbms_jobs you can enbale job execution by setting job_queue_processes parameter to a value higher than zero.
Do keep in mind the TRUE/FALSE paradox here, as it might be a little confusing.
Hope this helps!
Kehinde.
I knew what to do but couldn't navigate the package easily so I thought I should share... Oracle provides the dbms_scheduler package for achieving this.
Run scipt below on the oracle server to enable jobs.
exec dbms_scheduler.set_scheduler_attribute('SCHEDULER_DISABLED','FALSE');
To disable you can run
exec
dbms_scheduler.set_scheduler_attribute('SCHEDULER_DISABLED','TRUE');
However, If you are you are using dbms_jobs you can enbale job execution by setting job_queue_processes parameter to a value higher than zero.
Do keep in mind the TRUE/FALSE paradox here, as it might be a little confusing.
Hope this helps!
Kehinde.
No comments:
Post a Comment