What are the parameters for jobs in Oracle?
The parameters for jobs in Oracle include:
- job_name: the name of the job.
- The type of job, such as PL/SQL block, stored procedure, or script, will be specified.
- Task action: The specific action of a job, such as the code in a PL/SQL block or the name of a stored procedure.
- Start date: The date when the task will begin.
- The start time of the task.
- repeat_interval: the interval at which the task will repeat, can be set as one-time, daily, weekly, monthly, etc.
- End date: The deadline for the assignment.
- End time: The deadline for the assignment.
- enabled: specifies whether the job is enabled.
- auto_drop: Automatically delete the job after completion.
- Comments: Remarks and explanations on the assignment.
- Credential Name: The name of the credential used for accessing other databases or systems in the assignment.
- Destination name: The target name of the assignment, used to specify the output target of the job.
- job_class: the category or group to which the job belongs.
- Priority of job tasks.
- job_weight is the weight of the task, used for resource allocation.
- raise_events: specifies whether to trigger events when the job status changes.
- Owner of the destination: name of the target owner.
- destination attributes: target attributes used to set additional parameters for the output target.
- schedule_name: The scheduling name of the task, used to specify the scheduling rules for the job. These parameters can be set and managed using procedures and functions in Oracle’s DBMS_SCHEDULER package.