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; /
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter