How to purge the outgoing email queue on RSA Via Lifecycle and Governance
Originally Published: 2016-04-20
Article Number
Applies To
RSA Product/Service Type: Any
RSA Version/Condition: 6.9.1/7.0.0
Platform: Any
Issue
Resolution
commit;
delete from T_EMAIL_LOG where PROCESS_ACTION IS NULL AND COMPLETED_TIME IS NULL AND MESSAGE_DATA like '%<unique text in the email message>%';
Notes
To: test.user@vcloud.local
Message-ID: <AV-11-REF.1789840466.181461176392766.JavaMail.oracle@acm-691-p12.vcloud.local>
Subject: Test
MIME-Version: 1.0
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-Aveksa-Message-Reference: AV-11-REF
<html>
<head>
</head>
<body>
<p style="margin-top: 0">
This is a test email
</p>
</body>
</html>
Related Articles
How to use SAW purge data script 11Number of Views Purge Status column showing "In Progress" on the Archive page in RSA Identity Governance & Lifecycle 13Number of Views Data Purging does not complete in the configured time limit in RSA Identity Governance & Lifecycle 47Number of Views RSA Identity Governance and Lifecycle - Purge monitor tasks 37Number of Views Data purging fails with "ORA-20001: No jobs were found to delete" in RSA Identity Governance & Lifecycle 7.1.1 63Number of Views
Don't see what you're looking for?