Window Log Tab
(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. |
Job Scheduler (Requirements)
Specific system privileges are required in order for you to manage the Job Scheduler for connections to Oracle 10g and later.
Job Scheduler system privileges
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. |
INIT.ORA configuration file
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.)
Locate In Tree
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:
- DB Navigator
- Find objects Dialog
- Database Source Code Search
- Project Manager
- Describe
- Analyze Tool
- Quick Browse
- Edit Data
- Visual Object Editors
Output Window
The Output Window displays SQL Navigator messages and server output including Oracle errors.
Interpreting the output display
| User Interface | Description | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Tabbed Pages | There are tabs for each session, plus one for general messages not related to any particular session. | ||||||||
|
Icons & Color Coding |
The types of output are distinguished by font color. Icon markers make them even more noticeable.
|
|
|
Note: The Output window displays the results of program compilation and execution, including errors. You can view the full Oracle error description by double-clicking the error code in the Output window. The resulting dialog contains the error message description, cause and recommended actions, just as they appear in Oracle documentation. |
Actions
| Action | Description |
|---|---|
| Copy to the Clipboard | Select the text you want to copy. Right-click the selection and select Copy. |
| Clear | Right-click in the Output window and select Clear. |
| Print Contents | Right-click in the Output window and select Print. |