Change the Study Health Monitor data refresh frequency

The Study Health Monitor refreshes the data for all the studies in the Production life cycle every 15 minutes by default. If you want to change the data refresh value, you need to run the dmeDashboardSchChg.sql script that came with Oracle DMW.

To run the script and change the refresh frequency value:

1. Log in to SQL*Plus (not SQL Developer) as the APPS database user.
2. To invoke the script, locate the directory with the script. Then enter:
   sqlplus <APPS database user name>/<APPS database user pwd>@<database name>
3. Enter this command to run the script:
   SQL> @dmeDashboardSchChg.sql
4. Enter the following:
   DEFINE Frequency in Minutes = <time in 15 minute intervals, for example 15 (default), 30, 45, 60>