Create Program

This dialog box is used for creating a new 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.

Schema: Schema for the program.

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

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.

For the rest of the definition, click the tab for the program type (PL/SQL code, Stored Procedure, or Executable file).

PL/SQL tab

The program is a PL/SQL block. Job or program arguments are not supported when the job or program type is PLSQL_BLOCK. In this case, the number of arguments must be 0.

Enter or paste in the complete PL/SQL code, or edit the existing code.

Stored Procedure tab

The program is a PL/SQL or Java stored procedure, or an external C subprogram. Only procedures, not functions with return values, are supported. PL/SQL procedures with INOUT or OUT arguments are not supported.

Schema: Schema of the stored procedure. I not specified, the schema of the job is assumed.

Procedure: Name of the stored procedure.

Arguments: For each argument: name, data type, default value, and whether it is an input, output, or input/output argument.

Executable tab

The program is external to the database. External programs implies anything that can be executed from the operating system's command line. AnyData arguments are not supported.

Executable: Name of the external executable, including the full path name, but excluding any command-line arguments. If the action starts with a single question mark ('?'), the question mark is replaced by the path to the Oracle home directory for a local job or to the Scheduler agent home for a remote job. If the action contains an at-sign ('@') and the job is local, the at-sign is replaced with the SID of the current Oracle instance.

Arguments: For each argument: name, data type, default value, and whether it is an input, output, or input/output argument

Related Topics

Programs

Scheduling Jobs Using SQL Developer