dbms_scheduler example

dbms_scheduler.create_job example

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

Source

SELECT OWNER, JOB_NAME, ENABLED, JOB_CLASS, NEXT_RUN_DATE FROM DBA_SCHEDULER_JOBS WHERE OWNER NOT IN ('SYS') ORDER BY ENABLED, OWNER, JOB_NAME; -- Running jobs: SELECT OWNER, JOB_NAME, JOB_SUBNAME, JOB_STYLE, SESSION_ID, SLAVE_PROCESS_ID, ELAPSED_TIME, CPU_USED FROM DBA_SCHEDULER_RUNNING_JOBS ORDER BY OWNER, JOB_NAME;

Code answers related to "dbms_scheduler example"

Browse Popular Code Answers by Language

Answers for "dbms_scheduler example"

Code answers related to "dbms_scheduler example"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us