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

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