How to create a schedule job in Oracle database?

To schedule a job, first we have to create a schedule, then a program, and then a job.

1. We create a schedule using the following SQL command:

   1 2 3 4 5 6 7 8

   BEGIN    DBMS_SCHEDULER.CREATE_SCHEDULE (    Schedule_name => 'DAILYREPORTJOB',    Start_date => SYSTIMESTAMP,    Repeat_interval =>'FREQ=DAILY;BYHOUR=11; BYMINUTE=30',    Comments => 'DAILY REPORT JOB'    );    END;

2. And then we create a program using the following SQL command:

   1 2 3 4 5 6 7 8 9 10

   BEGIN    DBMS_SCHEDULER.CREATE_PROGRAM (    program_name => 'DAILYREPORTJOB',    program_type => 'STORED_PROCEDURE',    program_action => 'DAILYJOB.REPORTPROC'    number_of_arguments =>0,    enabled => TRUE,    comments => 'DAILY REPORT JOB'    );    END;

3. And now create the job :

   1 2 3 4 5 6 7 8

   BEGIN DBMS_SCHEDULER.CREATE_JOB (    job_name => 'DAILYREPORTJOB_RUN',    program_name => 'DAILYREPORTJOB',    schedule_name => 'DAILYREPORTJOB_SCHED',    enabled => FLASE,    comments => 'daily REPORT job'    );    END;

4. Finally enable the job:

   1	EXECUTE DBMS_SCHEDULER.ENABLE('DAILYREPORTJOB_RUN');