Create/Edit Program

This dialog box is used for creating or editing an Oracle Scheduler program, which can include creating a new program using details from an existing program (Create Like). For more information about job scheduling, see Scheduling Jobs Using SQL Developer.

(To create a program, SQL Developer internally uses the DBMS_SCHEDULER.CREATE_PROGRAM procedure.)

Name: Name of the program. The name has to be unique in the SQL namespace. For example, a program cannot have the same name as a table in a schema.

Enabled: If this option is specified, validity checks will be made and the program will be created enabled if all the checks are successful. If this option is not specified, the program is not created enabled.

Description: Optional text string that can be used to describe the program.

Type of program:

Properties tab

Enables you to set program properties. For most properties the default is null, but you can check the box to specify a value.

Detached: TRUE if the program is a detached job; otherwise, FALSE. Use a detached job to start a script or application that runs in a separate process, independently and asynchronously to the Scheduler. A detached job typically starts another process and then exits. Upon exit (when the job action is completed) a detached job remains in the running state. The running state indicates that the asynchronous process that the job started is still active. When the asynchronous process finishes its work, it must connect to the database and call DBMS_SCHEDULER.END_DETACHED_JOB_RUN, which ends the job.

Max Runs: Maximum number of runs before the program is marked as completed.

Max Failures: Maximum number of failures tolerated before the program is marked as broken.

Max Run Duration: Maximum run duration of the program.

Schedule Limit: Maximum delay time between scheduled and actual job start before a program run is canceled.

Related Topics

Programs

Scheduling Jobs Using SQL Developer