Schedule In Em Database Control Displays Incorrect Byhour Value (Doc ID 1354504.1)

Last updated on DECEMBER 06, 2016

Applies to:

Enterprise Manager for Oracle Database - Version 11.2.0.1 to 11.2.0.2 [Release 11.2]
Information in this document applies to any platform.

Symptoms

When you use the EM DBConsole to create a schedule of type 'Calendar' with a calendar expression like:
FREQ=DAILY;BYHOUR=06,18;BYMINUTE=00;BYSECOND=00
the schedule is later shown as a Standard type with
Interval (Days) 1
Repeat Time Hour:12 Minute:00 Second:00 AM

Also when you try again to edit the created schedule, all starting information is based on the incorrect 'Standard' type schedule settings.


Example:

1. Create a test schedule with EM DBConsole

Schedule Type 'Calendar'
with calendar expression like:
FREQ=DAILY;BYHOUR=06,18;BYMINUTE=00;BYSECOND=00

Use 'Show SQL':

BEGIN
sys.dbms_scheduler.create_schedule(
repeat_interval => 'FREQ=DAILY;BYHOUR=06,18;BYMINUTE=00;BYSECOND=00',
start_date => systimestamp at time zone 'America/New_York',
comments => 'None',
schedule_name => '"SYS"."CALENDAR_SCHEDULE"');
END;


2. View the resulting schedule (using the radiobutton for the schedule and 'View' button):

View Schedule: SYS.CALENDAR_SCHEDULE

General
Name CALENDAR_SCHEDULE
Schema SYS
Description None

Schedule Attributes
Repeat By Days
Interval (Days) 1
Repeat Time Hour:12 Minute:00 Second:00 AM  <===  This is the reported issue
Available to Start Jun 7, 2011 7:57:31 AM America/New_York
Not Available After

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