RE: Oracle Job Scheduling

From: Barun, Vlado <Vlado.Barun_at_JTV.com>
Date: Mon, 16 Feb 2009 16:27:26 -0500
Message-ID: <0181A069127F1944B484ED5B858D0C160C115FE281_at_KPMSPW02.jewelry.acn>



The scheduler can be disabled by setting the SCHEDULER_DISABLED attribute to true and then query DBA_SCHEDULER_GLOBAL_ATTRIBUTE.

For example:

16:24:00 sys_at_dpdbps03.play> execute dbms_scheduler.set_scheduler_attribute('SCHEDULER_DISABLED', 'TRUE');

PL/SQL procedure successfully completed.

16:24:04 sys_at_dpdbps03.play> select value from DBA_SCHEDULER_GLOBAL_ATTRIBUTE where attribute_name = 'SCHEDULER_DISABLED';

VALUE



TRUE Please be aware that the query returns no rows if SCHEDULER_DISABLED attribute is set to false:

16:24:13 sys_at_dpdbps03.play> execute dbms_scheduler.set_scheduler_attribute('SCHEDULER_DISABLED', 'FALSE');

PL/SQL procedure successfully completed.

16:25:32 sys_at_dpdbps03.play> select value from DBA_SCHEDULER_GLOBAL_ATTRIBUTE where attribute_name = 'SCHEDULER_DISABLED';

no rows selected

Regards,

Vlado Barun, M.Sc.
Sr. Manager, Database Engineering and Operations Jewelry Television
Mobile: 865 335 7652
Email: vlado.barun_at_jtv.com

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Nigel Thomas Sent: Saturday, February 14, 2009 1:10 PM To: Roger.Xu_at_dpsg.com
Cc: oracle-l_at_freelists.org
Subject: Re: Oracle Job Scheduling

Roger

You could also show them the init.ora parameter JOB_QUEUE_PROCESSES, and the scheduler attribute max_job_slave_processes:

"If JOB_QUEUE_PROCESSES is 0, DBMS_JOB is disabled, and the maximum number of job slave processes for Scheduler is controlled by the max_job_slave_processes Scheduler attribute." See the 11g documentation<http://download.oracle.com/docs/cd/B28359_01/server.111/b28310/appendix_a003.htm>.

It might also help to show them that noone has been granted the various scheduler privileges<http://download.oracle.com/docs/cd/B28359_01/server.111/b28310/schedadmin007.htm#i1011204>.

Regards Nigel
2009/2/13 Xu, Roger <Roger.Xu_at_dpsg.com<mailto:Roger.Xu_at_dpsg.com>> Will the following 2 SQL's against dba_jobs and dba_scheduler_jobs show auditors that we do not use Oracle Job Scheduling? Is there a better way to convince them?

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Feb 16 2009 - 15:27:26 CST

Original text of this message