data base job scheduler time limit

I found my best way to handle this situation.If you want to execute this proc after each 3 minutes between 6:00 am to 7:00 pm we can use like

    BEGIN
      DBMS_SCHEDULER.CREATE_JOB (
       job_name           =>  'UPDATE_UPLOADREQUESTSTATS_JOB',
       job_type           =>  'STORED_PROCEDURE',
       job_action         =>  'CON_UPDATE_UPLOADREQUEST_STATS',
       start_date         =>  'TRUNC(SYSDATE)',
       repeat_interval    => 'FREQ=DAILY;BYHOUR=6,7,8,9,10,11,12,13,14,15,16,17,18,19;BYMINUTE=3,6,9,12,15,18,21,24,27,30,33,36,39,42,45,48,51,54,57', 
       end_date           =>  '31-DEC-25 07.00.00 PM Asia/Riyadh',
       auto_drop          =>   FALSE,
       enabled             =>   TRUE,
       comments           =>  'TEVS JOB');
    END;

CLICK HERE to find out more related problems solutions.

Leave a Comment

Your email address will not be published.

Scroll to Top