Check how many records have passed their delete date

Document ID : KB000088686
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Check how many records have passed their delete date
Resolution:
Applicable to Applications Manager Versions:  v7.1, v8.0, v9.0
 
Detailed Description and Symptoms
This SQL query can be used to check the so_print_log table for records that have passed their deletion date.

It is recommended to backup your tables first before you run any kind of update or delete statement.
 

Investigation
To find out how many files are affected:
log into SQL*Plus as the Applications Manager Oracle user:
select count(*) from so_print_log where so_delete_date < sysdate;

To get the file info:
log into SQL*Plus as the Applications Manager Oracle user:
select so_operator, so_full_pathname from so_print_log where so_delete_date < sysdate;

Solution
Please contact Automic Support for the delete statements to delete the entries.