Finance | Project Operations, Human Resources, ...

How the Email History can be deleted which is older than 15 days in D365 F&O

(1) Share

Report

Posted on by Travor

Hi all,

Initially while Configuring Email Setup I had mentioned Email retention days 0(Default Setting). Now if I want to check the email History its taking too much time sometime not even loading.

I want to delete all the Email history which are older than 15 days.

Even after configuring the retention days to 15, the older emails are not getting deleted.

How can I delete the Email history which are older than 15days.

Regards,

Travor

I have the same question (0)

All responses (7)

Answers (0)

huijij 19,811 on at

Like (0)

Report

Moved to Finance forum.

Was this reply helpful? Yes No
Suggested answer

Mohit Rampal 12,565 Moderator on at

Like (0)

Report

Hi Travor, Not sure about 15 days retention period but you can check this batch job in your environment.

Was this reply helpful? Yes No
Suggested answer

GirishS 27,827 Moderator on at

Like (0)

Report

Hi Travor,

I can see one option to delete batch jobs based on days.

Navigate to System administration >> Periodic tasks >> "Batch job history clean up" or Batch job history clean up (custom).

I never used these two forms. But you can give it a try on how these two forms are implemented. At first you can try on any dev environment.

Thanks,

Girish S.

Was this reply helpful? Yes No
Patrick_van_Heijningen 21 on at

Like (0)

Report

Hi all,

I'm struggling with the same issues.
When checking my database usage, 50% of the data is consumed by AXDB.SYSOUTGOINGEMAILDATA

I would like to free-up some space, by deleting all data within this table older than 30 days.
I came across the Batch Job Clean Up with SysEmailHistoryCleanupBatch, and launched it as batchprocessing with a recurrence.

However, nothing seems to happen: after +/-24 hours, no data seems to be deleted from the Outgoing Email-list.

Did I forget something, or do something wrong?

Thanks!

Was this reply helpful? Yes No
Martin Dráb 237,967 Most Valuable Professional on at

Like (0)

Report

This thread is about Email history table, which is something that SysEmailHistoryCleanupBatch would help you with. But SysOutgoingEmailData is a different table.

SysEmailHistoryCleanupBatch cleans up SysEmailHistory and SysEmailAttachmentHistory, not SysOutgoingEmailData.

Was this reply helpful? Yes No
Patrick_van_Heijningen 21 on at

Like (0)

Report

Hi Martin,

Thanks for replying, and sorry for mixing up SysEmailHistory and SysOutgoingEmailTable.

Anyway, I'm still running on recurrence the SysEmailHistoryCleanupBatch.

But when checking the SysEmailHistory, no data is being deleted/cleaned.

What am I doing wrong here?

Was this reply helpful? Yes No
Martin Dráb 237,967 Most Valuable Professional on at

Like (0)

Report

It seems to me that you're deleting batch history related to SysEmailHistoryCleanupBatch, not executing SysEmailHistoryCleanupBatch class.

Was this reply helpful? Yes No