DBMS_SCHEDULER

create table t(c1 number);

• Creating the job including program and schedule:

BEGIN

  DBMS_SCHEDULER.CREATE_JOB(

   job_name => 'JOB_NAME',

   job_type => 'PLSQL_BLOCK',

   job_action => 'BEGIN insert into t values(10); END;',

   start_date => SYSTIMESTAMP,

   repeat_interval=>'FREQUENCY=minutely;INTERVAL=1',

   enabled => TRUE);

END;

/

• Create Program Separately:

BEGIN

  DBMS_SCHEDULER.CREATE_PROGRAM(

   program_name => 'PROG1',

   program_type => 'PLSQL_BLOCK',

   program_action => 'BEGIN insert into t values(10); END;',

   enabled=>true

);

end;

/

•  Creating the scheduler separately

BEGIN

  DBMS_SCHEDULER.CREATE_SCHEDULE('Sc1',

   start_date => SYSTIMESTAMP,

   repeat_interval => 'FREQ=DAILY',

   end_date => SYSTIMESTAMP +15); 

END;

/

• Creating a job with the program and schedule:

BEGIN

  DBMS_SCHEDULER.CREATE_JOB('Job2',

   program_name => 'PROG1',

   schedule_name => 'SC1',

   enabled => TRUE);

END;

/

EXEC DBMS_SCHEDULER.DROP_JOB('SCOTT.JOB_NAME');

EXEC DBMS_SCHEDULER.RUN_JOB('SCHEMA.JOB_NAME');

EXEC DBMS_SCHEDULER.stop_JOB('SCHEMA.JOB_NAME');