Chat now with support
Chat with Support

SQL Navigator for Oracle 7.6 - 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

Windows Tab

(Only for Oracle 10g release or later)

Assign resource plans to activate at different times such as during specific peak or off-peak periods.

Button Description

New

Click to create a window

  1. Enter a Window Name
  2. Select a Resource Plan from the drop-down list
  3. Select a Priority from the drop-down list
  4. Select a Schedule to attach to run during the window as appropriate
  5. Select the Duration (days, hours, months) for the window
  6. Specify a start date/time and end date/time for the window
  7. Select a repeat interval if desired

Click Save.

The new window will appear in the Windows list above.

Click Enabled to activate the window.

Save Save changes to a selected window or a new window.
Advanced Edit available Attribute Values for the selected item.
Open Activate the selected Window and commence running the scheduled jobs based on the durations currently entered. You can change the duration values if required.
Close Stop the currently active window. Any jobs using that window as their schedule which were started at the beginning of this window and have indicated that they must be stopped on closing of the window will be stopped.
Drop Remove the selected item from the database.

Window Groups Tab

(Only for Oracle 10g release or later)

Create a named windows group to which you can assign any number of previously created windows on the Windows Tab

Button Description

New

Click to create a window group

  1. Enter a Group Name
  2. Enter any Comments relevant to that windows group

Click Save.

The new group name will appear in the Window Group Name list on the left-hand side.

Select those Windows listed in the right pane that you want included in the group.

Click Enabled to activate the window group .

Save Save the window group.
Drop Remove the selected item from the database.

Job Classes Tab

(Only for Oracle 10g release or later)

The Scheduler provides the capability to group together jobs that have similar resource demands into job classes. A job class can be used to ensure all jobs within it utilize the same job class attributes, execute at a higher or lower priority than other jobs in other job classes and only allow jobs in the job class to start if there are sufficient resources available.

Button Description

New

Click create a job class

  1. Enter a Job Class Name.
  2. Select the appropriate Resource Consumer Group as defined for the database.
  3. Select the appropriate Service as defined for the database.
  4. Select a Logging Level for the database.
    • Off
    • Runs
    • Full
  5. Select the number of days the Log History will be retained.
  6. Enter any required Comments

Click Save.

Save Save the job class.
Advanced Edit available Attribute Values for the selected item.
Drop Remove the selected item from the database.

Job Log Tab

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

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating