job oracle exemple

Solutions on MaxInterview for job oracle exemple by the best coders in the world

showing results for - "job oracle exemple"
Lisa
27 Feb 2018
1BEGIN
2    DBMS_SCHEDULER.CREATE_JOB(
3      job_name => '"MYSCHEMA"."JOB_NAME"',
4      job_type => 'STORED_PROCEDURE',
5      job_action => 'MYSCHEMA.PROCEDURE',
6      number_of_arguments => 0,
7      start_date => to_timestamp_tz(
8        '2021-04-08 14:19:32.000000000 EUROPE/PARIS', 
9        'YYYY-MM-DD HH24:MI:SS.FF TZR'),
10      repeat_interval => 
11      'FREQ=DAILY;BYDAY=MON,TUE,WED,THU,FRI;BYHOUR=12;BYMINUTE=30;BYSECOND=0',
12      end_date => NULL,
13      enabled => FALSE,
14      auto_drop => FALSE,
15      comments => 'Job description');
16
17    DBMS_SCHEDULER.enable(
18            name => '"MYSCHEMA"."JOB_NAME"');
19END;