Online Documentation for SQL Manager for Oracle
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.
This field is not editable. Job ID is allocated by the server automatically.
This field stores the name of the user who creates the job.
Specify the next execution date and time for the job using the corresponding boxes.
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:
Use the spinner control below to define the Every ... minute(s) value.
Use the spinner control below to define the Every ... hour(s) value.
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.
Use the drop-down list to select the type of object (procedure or package) containing external C/Java procedures.
Use the drop-down list to select the package to be used by the job.
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.
If this option is enabled, Oracle parses the procedure associated with the job.
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.