Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- BEGIN
- DBMS_SCHEDULER.CREATE_JOB (
- job_name => 'decrease_prices_in_delayed_flights_job',
- job_type => 'STORED_PROCEDURE',
- job_action => 'delayed_flights_decrease_price',
- start_date => SYSTIMESTAMP,
- repeat_interval => 'FREQ=DAILY;BYHOUR=1',
- end_date => NULL,
- auto_drop => FALSE,
- comments => 'Regula numer 4');
- END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement