Reports Server Schedule Jobs Reset Start times if Server is Down

(Doc ID 344140.1)

Last updated on FEBRUARY 11, 2011

Applies to:

Oracle Clinical - Version: 4.5 and later   [Release: 4.5 and later ]
Information in this document applies to any platform.
=================================
***Checked for relevance on 11-FEB-2011***
=================================

Symptoms

In Oracle Clinical 4.5, if the reports server is shutdown for several hours, the schedule jobs that were suppose to be executed during the shutdown time are executed when the reports server restart and their schedule time is changed/readjusted by the reports server although the interval time originally scheduled
is respected.

For example:

Job RXCBVBVS was scheduled as OCLSCHED_RXCBVBVS_4630103 EVERY_24_HOURS_FROM_06:00_AUG_04,_2005
indicating that the job should be executed at 6:00 AM.

However, after shutdown/restart the reports server the process appear scheduled in reports queue
manager to be executed every 24 hours at 19:39:37.

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