CUP 5.3 Email notification Queue?

[Former Member]

Hi all,

Does anyone know if CUP queues the email notifications? We currenty have the Email Dispatcher Background Job turned off, and we are concerned that when we turn it back on, that all the new requests that are being entered will generate emails. So, if they are being queued, where are they queued, and can we delete them?

Thanks

Russell

[Former Member · Accepted solution]

I believe this information is store in the following table: virsa_ae_emllog

Once the email is sent the STATUS_FLAG is set to "CLOSED" and the UPDATETIME is set as well.

Before they are sent the UPDATETIME is null and STATUS_FLAG is "OPEN"

I gather the bkjob scans this table for "OPEN" records.

-J

[Former Member · Accepted solution]

Thanks all for your comments.

Good point about the SMTP server, but we deleted the "OPEN" entries in the VIRSA_AE_EMLLOG table.

There is also an SAP Note, 1312581 for this issue.

Thanks again,

Russell

[Former Member · Accepted solution]

If we want to keep emails but don't want to send them, we've used the following:

update SAPSR3DB.VIRSA_AE_EMLLOG set STATUS_FLAG='CLOSED' where STATUS_FLAG='OPEN' and EMAILID < 668 (or whatever number I'm on)

Am I the only person craving an admin tool similar to SOST in ERP, where we can see what's been sent, see errors, resend, cancel, etc?? Seems like an enhancement request to me.

[former_member196034]

Hi,

Yes it does queue the emails and when you run the email dispatcher you will get all the mails that were waiting to be sent.

I don't know which table contains the emails, if any.

I would try the following tables, perhaps they contain them:

VIRSA_AE_MESSAGE

VIRSA_AE_SCHEDULER

Let me know how you get on.

Rgds,

Babak

[Former Member]

Hi,

Instead of removing the email notifications, you can change the SMTP server name to a wrong server name and run the dispatcher job (do it couple of times to be safe). This will clear out the email queue. Now, you can switch it back to the actual SMTP server and you won't see those emails in the email queue.

Regards,

Alpesh