Oracle create job example

Oracle >  SYS.DBMS_SCHEDULER > CREATE_JOB

The CREATE_JOB procedure creates a single job. You can create multiple jobs using the CREATE_JOBS procedure.

Example:

Oracle create job example

BEGIN

    SYS.DBMS_SCHEDULER.CREATE_JOB (

            job_name => '"db"."job"',

            job_type => 'PLSQL_BLOCK',

            job_action => 'delete from item',

            number_of_arguments => 0,

            start_date => TO_TIMESTAMP('19-FEB-14 04.51.50.316000000 PM', 'DD-MON-RR HH.MI.SS.FF AM'),

            repeat_interval => 'FREQ=DAILY;BYHOUR=3',

            end_date => NULL,

            job_class => 'DEFAULT_JOB_CLASS',

            enabled => false,

            auto_drop => true,

            comments => NULL);

END;