RTCI Remote Access Purge policy mail gets sent daily at 9:00 to administrators, while SMP shows no active automation policy.
If you click on the Edit query link in the Data Source section, and then select the Resolved Query tab it will generate the SQL that is being submitted to the database server. If you copy and paste the resolved query results and run it against your database you will probably see (usually)
Total Records Left Records Deleted Records
0 0 0
This is why the policy is firing and sending an email. The query is actually returning one row. Albeit it isn't a row that we would want it to fire on.
By saving the policy, regardless of changes made, it will overwrite current settings, effectively stopping the emails from being sent.
Applies To
SMP 7 SP3, SP4 ; 7.1 SP1, SP2