Running HDR Maintenance Job
To run a HDR maintenance job, perform the following:
- Log in to the database as ORACLE_OWNER user and navigate to the $HDR_HOME/hdr_db/ets/db/execute folder.
- Execute the following commands:
su $ORACLE_OWNER
Use the preceeding command if you are not logged in as $ ORACLE_OWNER user.
cd $HDR_HOME/hdr_db/ets/db/execute
- Update the run_ets_maintenance.sql script with required job arguments.
Substitute FULL with the desired mode, if you are not running in Full mode.
The available modes are FULL, DEFAULT, CLEAN_STAGE, TRUNCATE_STAGE, CLEAN_ACTIVE, and CLASSIFICATIONS.
- Log in to the database as sysdba user.
- Execute the following command:
sqlplus sys@$SID as sysdba
Provide the password when prompted.
- Execute the following
script:
@ run_ets_maintenance.sql;
- Check the log file and execution report for status.
The log file is generated when the job starts and the execution report is generated when the job ends. These files are located in the $HDR_HOME/ hdr_db/ets/log folder.