My Oracle Support Banner

Oracle - DBMS_SCHEDULER - Repeat_internal => BYTIME Not Working (Doc ID 2138049.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 12.1]
Information in this document applies to any platform.
***Checked for relevance on 01-Sep-2017***


The BYTIME not working correctly in the repeat_interval of DBMS_SCHEDULER.CREATE_JOB

  job_name => 'GEN_605_PIX'
  ,start_date => TO_TIMESTAMP_TZ('2013/05/06 09:12:00.000000 EST5EDT','yyyy/mm/dd hh24:mi:ss.ff tzr')
  ,repeat_interval => 'FREQ=DAILY;BYTIME=045500,160000'
  ,end_date => NULL
  ,job_class => 'DEFAULT_JOB_CLASS'
  ,job_type => 'PLSQL_BLOCK'
  ,job_action => 'DECLARE
  P_REC INT; ......etc.

Job only runs at 160000.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.