Oracle® Database Administrator's Guide 11g Release 1 (11.1) Part Number B28310-01 |
|
|
View PDF |
This section contains reference information for Oracle Scheduler. It contains the following topics:
Table 28-2 lists the various Scheduler privileges.
Table 28-2 Scheduler Privileges
Privilege Name | Operations Authorized |
---|---|
System Privileges: |
|
|
This privilege enables you to create jobs, chains, schedules, programs, and credentials in your own schema. You will always be able to alter and drop jobs, schedules and programs in your own schema, even if you do not have the |
|
This privilege enables you to create, alter, and drop jobs, chains, schedules, programs, and regular credentials in any schema except |
|
This privilege is required to create jobs that run outside of the database. Owners of jobs of type ' |
|
This privilege enables your jobs to use programs or chains from any schema. |
|
This privilege enables your jobs to run under any job class. |
|
This is the most important privilege for administering the Scheduler. It enables you to create, alter, and drop job classes, windows, and window groups. It also enables you to set and retrieve Scheduler attributes, purge Scheduler logs, drop public credentials, set the agent password for a database. |
Object Privileges: |
|
|
This privilege can only be granted for programs, chains, and job classes. It enables you to create a job that runs with the program, chain, or job class. It also enables you to view object attributes. |
|
This privilege enables you to alter or drop the object it is granted on. Altering includes such operations as enabling, disabling, defining or dropping program arguments, setting or resetting job argument values and running a job. For programs, jobs, and chains, this privilege enables you to view object attributes. This privilege can only be granted on jobs, chains, programs and schedules. For other types of Scheduler objects, you can grant the jobs ( chains ( programs ( schedules ( |
|
This privilege authorizes operations allowed by all other object privileges possible for a given object. It can be granted on jobs, programs, chains, schedules and job classes. |
The SCHEDULER_ADMIN
role is created with all of the system privileges shown in Table 28-2 (with the ADMIN
option). The SCHEDULER_ADMIN
role is granted to DBA
(with the ADMIN
option).
The following object privileges are granted to PUBLIC
: SELECT
ALL_SCHEDULER_*
views, SELECT
USER_SCHEDULER_*
views, SELECT
SYS.SCHEDULER$_JOBSUFFIX_S
(for generating a job name), and EXECUTE
SYS.DEFAULT_JOB_CLASS
.
You can check Scheduler information by using many views. An example is the following, which shows information for completed instances of my_job1
:
SELECT JOB_NAME, STATUS, ERROR# FROM DBA_SCHEDULER_JOB_RUN_DETAILS WHERE JOB_NAME = 'MY_JOB1'; JOB_NAME STATUS ERROR# -------- -------------- ------ MY_JOB1 FAILURE 20000
Table 28-3 contains views associated with the Scheduler. The *_SCHEDULER_JOBS
, *_SCHEDULER_SCHEDULES
, *_SCHEDULER_PROGRAMS
, *_SCHEDULER_RUNNING_JOBS
, *_SCHEDULER_JOB_LOG
, *_SCHEDULER_JOB_RUN_DETAILS
views are particularly useful for managing jobs. See Oracle Database Reference for details regarding Scheduler views.
Note:
In the following table, the asterisk at the beginning of a view name can be replaced withDBA
, ALL
, or USER
.Table 28-3 Scheduler Views
View | Description |
---|---|
*_SCHEDULER_SCHEDULES |
These views show all schedules. |
*_SCHEDULER_PROGRAMS |
These views show all programs. |
*_SCHEDULER_PROGRAM_ARGS |
These views show all arguments defined for all programs as well as the default values if they exist. |
*_SCHEDULER_JOBS |
These views show all jobs, enabled as well as disabled. |
*_SCHEDULER_RUNNING_CHAINS |
These views show all chains that are running. |
*_SCHEDULER_CHAIN_STEPS |
These views show all steps for all chains. |
*_SCHEDULER_CHAINS |
These views show all chains. |
*_SCHEDULER_CHAIN_RULES |
These views show all rules for all chains. |
*_SCHEDULER_GLOBAL_ATTRIBUTE |
These views show the current values of Scheduler attributes. |
*_SCHEDULER_JOB_ARGS |
These views show all set argument values for all jobs. |
*_SCHEDULER_JOB_CLASSES |
These views show all job classes. |
*_SCHEDULER_WINDOWS |
These views show all windows. |
*_SCHEDULER_JOB_RUN_DETAILS |
These views show all completed (failed or successful) job runs. |
*_SCHEDULER_WINDOW_GROUPS |
These views show all window groups. |
*_SCHEDULER_WINGROUP_MEMBERS |
These views show the members of all window groups, one row for each group member. |
*_SCHEDULER_RUNNING_JOBS |
These views show state information on all jobs that are currently being run. |
*_SCHEDULER_JOB_LOG |
These views show all state changes made to jobs. |
*_SCHEDULER_WINDOW_LOG |
These views show all state changes made to windows. |
*_SCHEDULER_WINDOW_DETAILS |
These views show all completed window runs. |
*_SCHEDULER_CREDENTIALS |
These views show all credentials. |
*_SCHEDULER_JOB_ROLES |
These views show all jobs by Oracle Data Guard database role . |