Chat now with support
Chat with Support

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

Job Scheduler

Access the Oracle Job Scheduler.

A job assigns a task to a schedule. The job tells the schedule which tasks - either one-time tasks created "on the fly," or predefined programs - to run. A specific program can be assigned to one, multiple, or no schedule(s); likewise, a schedule may be connected to one, multiple, or no program(s).

Tab Description Oracle

Jobs Tab

Check the status and settings of existing jobs.

Create, run, schedule, edit and remove jobs.

All Oracle releases

Programs Tab Define or select programs to be executed. Oracle 10g release or later
Schedules Tab Define the frequency with which the Scheduler will execute a particular set of tasks. Oracle 10g release or later
Windows Tab Define time windows during which resource plans will be activated. Oracle 10g release or later
Window Groups Tab Create a named group with containing windows with similar scheduling properties for ease of management Oracle 10g release or later
Job Classes Tab Group together jobs that have similar resource demands into job classes to ensure best utilization of resources. Oracle 10g release or later
Job Log Tab Show the current status and information about jobs over a specified date range or by owner. Oracle 10g release or later
Window Log Tab Show the current status and information about Windows over a specified date range. Oracle 10g release or later

Jobs Tab

The Jobs function in the Job Scheduler allows you to create, run or schedule jobs.

Note that some of the functionality below is only available in Oracle 10g or later releases.

Button Description

New

Click to create a job. This opens the New Job Wizard:

  1. Enter a Job Name (for 10g or later)
  2. Select a Job Type (PS/SQL Block or Stored Procedure - in 10g or later)
  3. Click Next (for 10g or later)
  4. Enter the PL/SQL code or select a stored procedure to run
  5. Click Next
  6. Specify a start date, start time and frequency for your job to run
  7. Select a repeat frequency if desired
  8. Click Finish.

The new job will appear in the Jobs window.

Save

To attach a program, schedule or job class to a job (for 10g or later)

  1. Select the job to be scheduled.
  2. Select the program, schedule or job class to be attached to the job.
  3. Click Save.

To schedule a job (for 10g or later)

  1. Select the job to be scheduled.
  2. Click En (Enabled) next to the job.
  3. Select Start and End date and time.
  4. Click Calendar, choose the frequency and intervals for the job and click
  5. Click Save.

Advanced

Edit available Attribute Values for the selected item (for 10g or later).

Clone

Create a copy of the selected item (for 10g or later).

Run

To run a job

  1. Select the job to be run.
  2. Click Enabled next to the job.
  3. Click Run.

Drop

Remove the selected item from the database (for 10g or later).

Programs Tab

(Only for Oracle 10g release or later)

A program defines what the Scheduler will execute. A program's attributes include its name, type (for example: a PL/SQL procedure or anonymous block), and the action it is expected to perform. A program can also accept zero to many arguments, which makes it a flexible building block for constructing schemes of tasks to be scheduled.

Button Description

New

Click to create a program

  1. Enter a Program Name.
  2. Select a Type, that is PL/SQL Block, Stored Procedure or Executable.
  3. If you do not want the program to be enabled by default, clear the Enabled check box.
  4. Define the Action the program is to perform.
  5. For PL/SQL Block or Executable, enter the relevant command string.
  6. For Stored Procedure, select one of the available stored procedures from the database.
  7. Enter any Comments if required
  8. Click Save.
Save Save changes to a selected program or a new program.
Advanced Edit available Attribute Values for the selected item.
Drop Remove the selected item from the database.

Schedules Tab

(Only for Oracle 10g release or later)

A schedule defines when and at what frequency the Scheduler will execute a particular set of tasks. A schedule's attributes include the date on which a set of tasks should begin, how often the tasks should be repeated and when the set of tasks should no longer be executed, either as of a specified date and time, or after a specified number of repetitions.

Button Description

New

Click to create a schedule

  1. Enter a Schedule Name.
  2. Select Start and End dates and times.

  3. Click Calender, select the required Frequency and Interval and click OK.

  4. Enter any Comments if required
  5. Click Save.
Save Save changes to a selected schedule or a new schedule.
Advanced Edit available Attribute Values for the selected item.
Drop Remove the selected item from the database.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating