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

Last updated on SEPTEMBER 02, 2017

Applies to:

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

Symptoms

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

SYS.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.

Cause

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 hundreds of Community platforms