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

EmailHistoryJob appears to be stuck, how to we find the number of emails that are backlogged

Thriller
New Contributor III
New Contributor III

EmailHistoryJob appears to be stuck, how to we find the number of emails that are backlogged. Also, can you please provide all available status keys for emails along with their description

5 REPLIES 5

rushikeshvartak
All-Star
All-Star

From v24.2 onwards this can be seen on UI using email history viewer option.

otherwise you can check running below query from data analyzer

select * from emailhistory

 

resolution - restart server 

refer https://forums.saviynt.com/t5/identity-governance/access-request-emails-stuck-in-emailhistory-queue/...


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

Hi @rushikeshvartak 
What does status (1, 4 and 5) indicate?
In Email History Viewer List, it is only showing the ones that have status as 'Failure'

Thriller_0-1715653944124.png

 

  • 1 - SENDNOW

    2- SENT

    15 - INPROCESS

    404 - ERROR WHILE SEND

    Usually 5,15,404 are considered as bad statuses as they would result in filling up emailhistory_archive table with duplicate values. Hence clean up can be done to remove them.


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

Thank you for the info
What does 4 and 5 indicate?
Also, what's the query to perform the clean-up of emailhistory_archive table?

You can't do cleanup of emailhistory_Archive table.

5 is bad status

4 for reminder templates


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