Schedule In Em Database Control Displays Incorrect Byhour Value
(Doc ID 1354504.1)
Last updated on AUGUST 22, 2018
Enterprise Manager for Oracle Database - Version 18.104.22.168 to 22.214.171.124 [Release 11.2] Information in this document applies to any platform.
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.
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!