Which two statements correctly describe the relationship among the Scheduler components:
job, program, and schedule? (Choose two)
A.
A job is specified as part of a program definition
B.
A program can be used in the definition of multiple jobs
C.
A program and job can be specified as part of a schedule definition
D.
A program and schedule can be specified as part of a job definition
Explanation:
Programs
A program object (program) describes what is to be run by the Scheduler. A program
includes:
An action: For example, the name of a stored procedure, the name of an executable found in
the operating system file system (an “external executable”), or the text of a PL/SQL
anonymous block.
A type: STORED_PROCEDURE, PLSQL_BLOCK, or EXTERNAL, where EXTERNAL
indicates an external executable.
Number of arguments: The number of arguments that the stored procedure or external
executable accepts.
A program is a separate entity from a job. A job runs at a certain time or because a certain
event occurred, and invokes a certain program. You can create jobs that point to existing
program objects, which means that different jobs can use the same program and run the
program at different times and with different settings. With the right privileges, different users
can use the same program without having to redefine it. Therefore, you can create program
libraries, where users can select from a list of existing programs.If a stored procedure or external executable referenced by the program accepts arguments,
you define these arguments in a separate step after creating the program. You can
optionally define a default value for each argument.
Oracle Scheduler
Program objects (programs) contain metadata about the command that the Scheduler will
run, including default values for any arguments. Schedule objects (schedules) contain
information about run date and time and recurrence patterns. Job objects (jobs) associate a
program with a schedule. To define what is executed and when, you assign relationships
among programs, schedules, and jobs.
A job is the combination of a schedule and a program, along with any additional arguments
required by the program.