Oracle 12.1.0.2 - DBMS_SCHEDULER - Repeat_internal => BYTIME Not Working
(Doc ID 2138049.1)
Last updated on JANUARY 07, 2025
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
The BYTIME not working correctly in the repeat_interval of DBMS_SCHEDULER.CREATE_JOB
SYS.DBMS_SCHEDULER.CREATE_JOB
(
job_name => 'TEST'
,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.
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |