(Only for Oracle 10g release or later)
You can view a history of the Job Scheduler transactions over a range of dates, including all job owners if desired.
| Field | Description |
|---|---|
| From date / To date | Select the Start and End date range to view. |
| Owner | Select job owner to use in log display. |
| Refresh | Update the display. |
(Only for Oracle 10g release or later)
You can view a history of the Job Scheduler window transactions over a range of dates.
| Field | Description |
|---|---|
| From date / To date | Select the Start and End date range to view. |
| Refresh | Update the display. |
Specific system privileges are required in order for you to manage the Job Scheduler for connections to Oracle 10g and later.
The system privileges associated with the Job Scheduler (for Oracle 10g and later) are as follows:
|
System Privilege |
Purpose… |
|---|---|
|
CREATE JOB |
Enables you to create jobs, schedules and programs in your own schema. Note: You can always alter and drop jobs, schedules and programs which you own, even when you do not have the CREATE JOB privilege. |
|
CREATE ANY JOB |
Enables you to create jobs, schedules, and programs in any schema. This effectively gives the grantee the ability to run code as any user so it must be issued with care. |
|
EXECUTE ANY PROGRAM |
Enables jobs the ability to use programs from any schema. |
|
EXECUTE ANY CLASS |
Enables jobs to run under any job class. |
|
MANAGE SCHEDULER |
Enables you to create, alter and drop job classes, windows and window groups. It also enables you to purge scheduler logs and modify scheduler attributes. |
In order to successfully use the Job Scheduler, you may also need to adjust the settings on your server in the INIT.ORA configuration file to allow use of the DBMS_JOBS package (Oracle 9.2 and earlier) or the DBMS_SCHEDULER (Oracle 10g and later).
The following minimum settings are recommended:
job_queue_processes = 2
job_queue_interval = 10
job_queue_keep_connections = false
(Remember to restart your server to apply these settings.)
When an object is open in an editing window, and you want to see where that object resides in the schema, you can use Locate in Tree to jump to that object’s node in the DB Navigator tree. This action expands all intermediate nodes and displays the object’s details—such as privileges and columns.
Locate in Tree is available from the following windows:
