Deleting Queued Email Alerts

[Former Member]

Because of an issue with our email server, we've been queueing up alerts to be emailed out. We'd like to simply delete that queue of alerts. Is this possible? Where are the alerts maintained?

We're running MII 12.0.3.

Thanks for the help!

David Macindoe

[Former Member · Accepted solution]

It works on given below URLs(SAP xMII 11.5), just check it for 12.0 by replacing Lighthammer with xMII

Type the following uniform resource locator (URL) into the command line of your browser

http://<servername>/Lighthammer/ActivePortal/AlertManager.irpt

uncheck the Email notification box

To view the alert log, type the following URL into the command line of your browser:

http://<servername>/Lighthammer/ActivePortal/ViewAlertLog.irpt. Here you can view your active alerts, view all of your alerts, and acknowledge your alerts.

[Former Member · Accepted solution]

Thanks, Ram.

I'm not seeing anything in my AlertLog yet I'm still receiving emails that have been queued up since the mail server went down. Lots of emails!

Is there no way to just delete these alerts wherever they're being queued?

David

[jcgood25 · Accepted solution]

Do a New SQLQuery against the ActivePortal data server and select Command Mode.

Then use this query:

UPDATE AlertAckLog SET EMailPending = 'N' WHERE EMailPending = 'Y'

This will turn off the email flag that the mailer process looks for.

Regards,

Jeremy

[Former Member · Accepted solution]

Thanks, Jeremy. That took care of it!

David