Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Clear Email queue

jpaull
New Contributor
New Contributor

Need to clear email queue with out sending emails when running email history job

5 REPLIES 5

rushikeshvartak
All-Star
All-Star

Not sure what is rationale behind question, possible ways

1. kill Email History Job

2. Remove email address from Users 

3.  Update email sent status in emailhistory table.

 


Regards,
Rushikesh Vartak
If you find this response useful, kindly consider selecting 'Accept As Solution' and clicking on the 'Kudos' button.

We run the email history job manually in lower environment so it has not run in some time. 

Maybe I am not clear when the email gets created. I thought it was when they kicked off the campaign.

My analytics report shows I have several hundred email in queue which I don't want sent. They would confuse the end users.

Is it a simple as updating status? My understanding is that is what the email history job does after it sends the email.

How do I update the email sent status in email history table?

Thanks for you help.

As you have mentioned you have analytics which shows emails are pending to send update that table with appropriate status


Regards,
Rushikesh Vartak
If you find this response useful, kindly consider selecting 'Accept As Solution' and clicking on the 'Kudos' button.

sahajranajee
Saviynt Employee
Saviynt Employee

Hello,

You can figure out all the email templates that will be used when the email history job runs by running an analytics report like :
select distinct(emailtemplate) from emailhistory;

Since you are in a non prod/dev environment, just update the TO/CC fields to the email template to a valid static email/temporary email id and run the email history job.

 


Regards,
Sahaj Ranajee
Sr. Product Specialist

jpaull
New Contributor
New Contributor

Thank you that worked. I do have some that did not go that had errors. See below. The email address shown with errors is a valid email and there were others that were sent. How do I remove these from history or figure out why they did not send?

Error sending email [null]
Error sending email [null]
Error sending email [XXXXX.XXXX@XXX.XXX]
Error sending email [XXXXX.XXXX@XXX.XXX]
Error sending email [XXXXX.XXXX@XXX.XXX]
Error sending email [XXXXX.XXXX@XXX.XXX]
Error sending email [XXXXX.XXXX@XXX.XXX]
Error sending email [XXXXXXXX.XXXXXXXXXX@XXX.XXX]
Error sending email [XXXXX.XXXX@XXX.XXX]

[This post has been edited by a moderator to remove personally identifiable information (emails) to abide by the Saviynt Community Terms of Use and Participation Guidelines.]