RE: Oracle Job Scheduling

From: Goulet, Richard <Richard.Goulet_at_parexel.com>
Date: Mon, 16 Feb 2009 10:09:01 -0500
Message-ID: <23C4836D8E9C5F4280A66C0C247BC16F23EC14F1_at_US-BOS-MX011.na.pxl.int>

On top of that, who really cares if job scheduling in being used. Any ERP package has a job scheduler that it uses, why should Oracle's be any different. And if your on 10g or higher then the database does create jobs for AWR & other maintenance tasks. Sheesh, these auditors are getting out of hand.  

Dick Goulet  

---

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/schedadm
in007.htm#i1011204> .

Regards Nigel

2009/2/13 Xu, Roger <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 - 09:09:01 CST