Chat now with support
Chat with Support

SQL Navigator for Oracle 8.0 - User Guide

Quick Overview Working With SQL Navigator Navigation Oracle Logon Code Editor Visual Object Editors Team Coding and Version Control Systems Modules, Windows And Dialogs
Analyze Tool Auto Describe Tool Benchmark Factory Bookmarks Dialog Capture Web Output Change Logon Password Dialog Code Analysis Code Assistant Code Road Map Code Templates Code Test Database Source Code Search Dialog DB Navigator Describe Difference Viewer Edit Data ER Diagram Explain Plan Tool Export Table Find and Replace Dialog Find objects Dialog Find Recycle Bin Objects Dialog Formatting Options HTML Viewer Import HTML as PL/SQL Import Table Java Manager Job Scheduler Locate In Tree Output Window PL/SQL Profiler Profile Manager Project Manager Publish Java to PL/SQL Quick Browse Rename Object Search Knowledge Xpert Select DB Object Dialog Server Output Server Side Installation Wizard Session Browser Source Preview SQL Modeler SQL Optimizer Task Manager Web Support Configuration Dialog Wrap Code
View | Preferences About Us

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:

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.

Color

Data type

Blue

Server output

Red

Error Messages

Black

Other processing messages

 

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.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating