CREATEJOB - Example - Oracle DBA - Named Program and Schedule

Q.  Based on the existing program which way is used to CREATE_JOB?

BEGIN
DBMS_SCHEDULER.CREATE_JOB (
job_name => 'my_new_job3',
program_name => 'my_saved_program1',
schedule_name => 'my_saved_schedule1');
END;

- Published on 03 Aug 15

a. Named Program
b. Named Schedule
c. Named Program and Schedule
d. All mentioned above

ANSWER: Named Program and Schedule
 

    Discussion

  • Nirja Shah   -Posted on 25 Aug 15
    -The following are the methods for creating jobs

    -Named Program - A job can be created by pointing to a named program instead of inlining its action.
    -We must specify the value for the program_name in the CREATE_JOB procedure when creating the job and do not specify the values for job_type,job_action and number_of_arguments.

    -Named Schedule - A job can be created by pointing to a named schedule instead of inlining its schedule.
    -We must specify the value for schedule_name in the CREATE_JOB procedure when creating the job and do not specify the values for start_date, repeat_interval, and end_date.

    -Named Programs and Schedule - A job can also be created by pointing to both a named program and a named schedule.

Post your comment / Share knowledge


Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)