The purpose of this article is to clear the unsent alerts from the database. If email alerts that are supposed to go out get stuck or unable to be sent, below is the query that can be utilized to delete the alerts. Please be advised that running the below query will result in the alerts being deleted and it is advisable to run the below query at the recommendation of the Infogix Support.
- Run below query to count the number unsent alerts:
SELECT count(*) FROM EXCEPTION WHERE ALERTGENERATED=0
- Run the below query only if the it has been recommended by the Infogix Support as all the unsent alerts will result in being unrecoverable.
3. You can re-run the query specified in #1 to check the new count of the email alert as it should go down to zero and new email alerts should start going out.