We previously talked about the Program and the Schedule, and we defined that multiple Jobs can share a single Program and that a single Schedule can apply to multiple Jobs.

We will use the Create_Job procedure to create a Job that uses the Program we created earlier, which is named Prog_account.

We will also use the Schedule that we created earlier, which is named Daily.

begin

dbms_scheduler.create_job(

job_name=>'new_job',

program_name=>'prog_account',

schedule_name=>'dialy',

enabled=>true);

end;

We can create additional Jobs that are linked to the same Program and Schedule.

Sometimes, we need to execute a Job immediately without waiting for the scheduled time. In such cases, we can use the RUN_JOB procedure to execute the Job in real-time.