There may be times when the email queue in RSA Identity Governance & Lifecycle contains pending emails waiting to be sent and these emails are no longer needed. This can happen when a Change Request has been cancelled or Review Results have been deleted. There is no way to cancel the emails associated with the cancelled Change Request or deleted Review.
This RSA Knowledge Base Article explains how to remove pending emails from the email queue so that they will not be sent.
Follow the steps below to identify and remove the pending emails from the queue:
Ensure that all other processing has stopped and thatno new Change Requests/Reviews are being generated as this process will cancel all pending emails regardless of the Change Request/Review to which they are associated. Consider putting the system into Maintenance mode (Admin > System > Maintenance tab > Edit > toggle Maintenance ModeOn.)
Execute the following query as AVUSER in SQL Developer or SQL*Plus to generate a list of all pending emails. Ensure that the contents of this list agrees with the emails that you wish to terminate.
select * from T_EMAIL_LOG where COMPLETED_TIME is null;