Clear Email queue

[jpaull]

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

[rushikeshvartak]

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.

[jpaull]

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.

[rushikeshvartak]

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

[sahajranajee · Accepted solution]

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.

[jpaull]

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.]