SQL Navigator for Oracle 7.4 - Release Notes

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.

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.

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

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

To run a job

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