Can a job be created by pointing to both a named program & schedule. - Oracle DBA

Q.  Can a job also be created by pointing to both a named program and schedule.
- Published on 28 Jul 15

a. True
b. False

ANSWER: True
 

    Discussion

  • Nirja Shah   -Posted on 25 Aug 15
    -A job can also be created by pointing to both a named program and schedule.

    -An example of using the CREATE_JOB procedure with a named program and schedule is the following statement, which creates a regular job called my_new_job3 based on the existing program my_saved_program1 and the existing schedule my_saved_schedule1:

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

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.)