RE: Oracle Job Scheduling
- From: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
- To: <nigel.cl.thomas@xxxxxxxxxxxxxx>, <Roger.Xu@xxxxxxxx>
- Date: Mon, 16 Feb 2009 10:09:01 -0500
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Nigel Thomas
Sent: Saturday, February 14, 2009 1:10 PM
To: Roger.Xu@xxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxx>
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?
Other related posts:
