Creating jobs correct methods - Oracle DBA

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.
  -For example, the following CREATE_JOB procedure 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