02/14/2023 03:26 AM - edited 02/14/2023 02:21 PM
Hi Team,
Can someone help with the explanation for different status numbers in emailhistory / emailhistory_archive table? Couldn't find it explained in this document - https://docs.saviyntcloud.com/bundle/EIC-Database-Schema-Reference/page/Content/Database-Schema-Refe...
In emailhistory table, some of the values in status column that I noticed are below. There might be other status values as well. Appreciate the insights.
1, 5, 7, 15, 404
-Siva
02/14/2023 03:59 PM
Hi @Siva ,
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.
Thanks