Online Documentation for SQL Manager for Oracle

Job Editor


Job Editor allows you to define job properties. It opens automatically when you create a new job and is available on editing an existing one.

 

Job ID

This field is not editable. Job ID is allocated by the server automatically.

 

Job owner

This field stores the name of the user who creates the job.

 

Jobs - Job Editor - General

 

General

 

Next time

Specify the next execution date and time for the job using the corresponding boxes.

 

CheckBox Periodically

This option specifies recurrent execution of the job.

 

Set the interval between executions for a specified job. Use the Every minute, Every hour, Every day and Custom interval fields for defining a recurrence period.

 

Specify the periodicity of the job execution:

 

RadioButton Every minute

Use the spinner control below to define the Every ... minute(s) value.

RadioButton Every hour

Use the spinner control below to define the Every ... hour(s) value.

RadioButton Every day

Use the spinner control below to define the Every ... day(s) value.

 

If more convenient, you can use the Custom interval field to specify the execution interval for the job.

 

Jobs - Job Editor - PLSQL code

 

PL/SQL Code

 

Object type

Use the drop-down list to select the type of object (procedure or package) containing external C/Java procedures.

 

Schema

Use the drop-down list to select the schema that contains the stored procedure or package.

 

Package

Use the drop-down list to select the package to be used by the job.

 

Routine

Use the drop-down list to select the stored procedure to be used by the job.

 

If necessary, you can also create a PL/SQL anonymous block directly in the What editor area.

 

CheckBox Parse

If this option is enabled, Oracle parses the procedure associated with the job.

 

CheckBox Broken

Disables job execution. Oracle does not attempt to run broken jobs. However, you can force a broken job to run.

 

When finished, press OK to run Execute Script that creates the specified job.

 


See also:

Managing jobs