Re: Oracle Job Scheduling

From: Nigel Thomas <nigel.cl.thomas_at_googlemail.com>
Date: Sat, 14 Feb 2009 18:09:30 +0000
Message-ID: <53258cd50902141009u3eb37290l7b4ceaff801070f7_at_mail.gmail.com>



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>

> 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 Sat Feb 14 2009 - 12:09:30 CST

Original text of this message