Answers for "oracle job sql"

SQL
4

job oracle exemple

BEGIN
    DBMS_SCHEDULER.CREATE_JOB(
      job_name => '"MYSCHEMA"."JOB_NAME"',
      job_type => 'STORED_PROCEDURE',
      job_action => 'MYSCHEMA.PROCEDURE',
      number_of_arguments => 0,
      start_date => to_timestamp_tz(
        '2021-04-08 14:19:32.000000000 EUROPE/PARIS', 
        'YYYY-MM-DD HH24:MI:SS.FF TZR'),
      repeat_interval => 
      'FREQ=DAILY;BYDAY=MON,TUE,WED,THU,FRI;BYHOUR=12;BYMINUTE=30;BYSECOND=0',
      end_date => NULL,
      enabled => FALSE,
      auto_drop => FALSE,
      comments => 'Job description');

    DBMS_SCHEDULER.enable(
            name => '"MYSCHEMA"."JOB_NAME"');
END;
Posted by: Guest on August-27-2021
0

oracle job class

SELECT JOB_CLASS_NAME,
       RESOURCE_CONSUMER_GROUP,
       SERVICE,
       LOGGING_LEVEL,
       LOG_HISTORY,
       COMMENTS
FROM DBA_SCHEDULER_JOB_CLASSES
ORDER BY JOB_CLASS_NAME;
Posted by: Guest on September-03-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language