Chat now with support
Chat mit Support

SQL Navigator for Oracle 7.4 - Release Notes

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).

 

Related Topics

Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen