Advertisement
Guest User

Untitled

a guest
Apr 5th, 2020
134
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.42 KB | None | 0 0
  1. BEGIN
  2.   DBMS_SCHEDULER.CREATE_JOB (
  3.    job_name           =>  'decrease_prices_in_delayed_flights_job',
  4.    job_type           =>  'STORED_PROCEDURE',
  5.    job_action         =>  'delayed_flights_decrease_price',
  6.    start_date         =>  SYSTIMESTAMP,
  7.    repeat_interval    =>  'FREQ=DAILY;BYHOUR=1',
  8.    end_date           =>   NULL,
  9.    auto_drop          =>   FALSE,
  10.    comments           =>  'Regula numer 4');
  11. END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement