Running HDR Maintenance Job

To run a HDR maintenance job, perform the following:

1. Log in to the database as ORACLE_OWNER user and navigate to the $HDR_HOME/hdr_db/ets/db/execute folder.
2. 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
   

3. 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.

4. Log in to the database as sysdba user.
5. Execute the following command:

   sqlplus sys@$SID as sysdba
   

   Provide the password when prompted.

6. Execute the following script:

   @ run_ets_maintenance.sql;
   

7. 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.