CREATE PLSQL JOB

PHOTO

Tue Jan 04 2022 09:17:23 GMT+0000 (Coordinated Universal Time)

BEGIN
  DBMS_SCHEDULER.CREATE_JOB (
   job_name           =>  'JOB_UPDATE_RATES_FUEL_MONTHLY',
   job_type           =>  'PLSQL_BLOCK',
   job_action         =>  'PR_UPDATE_RATES_FUEL_MONTHLY;',
   start_date         =>   TO_DATE('2022-01-28 01:30:00', 'YYYY-MM-DD HH24:MI:SS'),
   enabled 			  =>   TRUE,
   repeat_interval    =>  'freq=monthly;byhour=01;byminute=30;', 			
   job_class          =>  'DEFAULT_JOB_CLASS',
   comments           =>  'UPDATE RATES FUEL MONTHLY');
END;
/

COPY