11g scheduling -- job usage

11g scheduling -- job uses Runtime (www.2cto.com job_name IN VARCHAR2, job_type IN VARCHAR2, job_action IN VARCHAR2, number_of_arguments IN PLS_INTEGER DEFAULT 0, start_date in timestamp with time zone default null, repeat_interval IN VARCHAR2 default null, end_date in timestamp with time zone default null, job_class IN VARCHAR2 DEFAULT 'default _ JOB_CLASS ', enabled in boolean default false, au To_drop in boolean default true, comments IN VARCHAR2 default null, credential_name IN VARCHAR2 default null, destination_name IN VARCHAR2 default null); JOB_NAME: name of the specified task, required value, make sure that the specified name is unique. JOB_TYPE: Operation Type of a task. It is a required value and has the following optional values: PLSQL_BLOCK: indicates that the task runs a PL/SQL anonymous block. STORED_PROCEDURE: indicates that the task executes the ORACLE process (including PL/SQL PROCEDURE and JAVA PROCEDURE). This parameter value is specified in this example. EXECUTABLE: indicates that the task runs an external program, such as an operating system command. CHAIN: indicates that the task runs a CHAIN. JOB_ACTION: The operation performed by the task. A required value must match the parameter specified in the JOB_TYPE. For example, for PL/SQL anonymous blocks, the specific representatives of PL/SQL blocks can be placed here, similar to DECLARE .. BEGIN .. this type of END. If it is an ORACLE process, the specific process name should be specified here. Note that, due to task execution, there will be no output even if there are parameters such as OUT in the process. START_DATE: specifies the time when the task is executed for the first time. This parameter can be blank. If it is null, the task is executed immediately. The effect is equivalent to specifying this parameter value as SYSDATE. NUMBER_OF_ARGUMENTS: specifies the number of parameters that need to be included during JOB execution. The default value is 0. Note that when the JOB_TYPE column value is PLSQL_BLOCK or CHAIN, this parameter must be set to 0, in either case, parameters are not supported. END_DATE: Specifies the task expiration time. The default value is NULL. After the task expires, the STATE of the task is automatically changed to COMPLETED, and ENABLED is set to FALSE. If this parameter is set to null, it indicates that the task will never expire and will be executed repeatedly according to the cycle set by REPEAT_INTERVAL until the set MAX_RUNS or MAX_FAILURES value is reached. JOB_CLASS: Specifies the CLASS associated with the task. The default value is DEFAULT_JOB_CLASS. For information about job class, follow the subsequent articles in this series. ENABLED: Specifies whether the task is ENABLED. The default value is FALSE. "FALSE" indicates that the task is not executed unless it is manually called or changed to "TRUE. AUTO_DROP: When this flag is set to TRUE, ORACLE will automatically delete the created task that has expired when the conditions are met; the maximum number of running tasks has reached the value of MAX_RUNS; the REPEAT_INTERVAL parameter is not specified for the task and runs only once. The default value of this parameter is TRUE. When executing the CREATE_JOB process, you can manually set this flag to FALSE. When the parameter value is set to FALSE, the task will not be automatically deleted even if the preceding conditions are met, the only situation that can cause the task to be deleted is that the user actively calls the DROP_JOB process.