(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. |
Quick Overview
Working With SQL Navigator
Oracle Sessions
Finding Objects
Working With Objects
Web Development
Java Source Code
Analysis And Tuning
Team Coding and Version Control
Navigation
Main Menu
Oracle Logon
File Menu
Edit Menu
Search Menu
View Menu
Session Menu
Object Menu
Tools Menu
Team Coding Menu
Help Menu
Task Bar
Toolbars
Component List
Connection Category Color
Main Menu Keyboard Shortcuts
Customize The Screen Layout
Oracle Logon Dialog
Oracle TNS Configuration Dialog
Advanced Service Options Dialog
Address List Options Dialog
DBA Dictionary Views
Troubleshooting Connections to Oracle
Command Line Parameters
Code Editor
Code Editor SQL
Code Editor PL/SQL
Edit, Compile And Execute
Visual Object Editors
SQL*Plus command support
Auto Code Completion
Scan Defines/Substitutions
New Stored Object Dialog
SQL Statement CRUD Matrix Dialog
SQL Query Results
SQL Query Results Data Grid
SQL Query Log (The Spool Tab)
Export Data Dialog
Viewers: LOB, XML, Array
PL/SQL Execution Console
Code Editor Keyboard Shortcuts
Toolbox
Cluster Editor
Constraint Editor
Database Link Editor
Index Editor
Nested Table Editor
Profile Editor
Redo Log Group Editor
Role Editor
Materialized View Editor
Sequence Editor
Synonym Editor
Table Editor
User Editor
Varray Editor
View Editor
Java Editor
Instance Property Editor
Team Coding and Version Control Systems
Objects Supported by Team Coding
Administer Team Coding
Configure Team Coding
Modules, Windows And Dialogs
Configure Concurrent Version Systems (CVS)
Configure Git
Configure IBM Rational ClearCase
Configure Perforce (P4)
Configure Serena PVCS Version Manager
Configure Subversion
Configure Team Foundation Server
Team Coding Status
Team Coding Manager
Provider logon
Check in and Check out
Version Control Systems
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
View | Preferences
Jobs Tab
Programs Tab
Schedules Tab
Windows Tab
Window Groups Tab
Job Classes Tab
Job Log Tab
Window Log Tab
Job Scheduler (Requirements)
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
General
About Us
General | User Interface
General | "Drop" and "Truncate" safety options
General | Session
General | Default Tables
General | Explain Plan
General | Code Assistant
General | Printing
General | Object Editors
General | Task Bar
Extract DDL
Extract DDL | General
Extract DDL | Table/View Specific
Extract DDL | Constraints
Extract DDL | Materialized Views/Snapshots
Extract DDL | Users
Project Manager
Code Editor
Lob Viewer
Team Coding
Keyboard Shortcuts
Window Log Tab
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
Modules, Windows And Dialogs > 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
Modules, Windows And Dialogs > 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. |