Database Log Clean Up Batch Job

(1) Share

Report

Posted on by MBates237

211

Hello everyone.

My organisation's database log has become incredibly large and I'm trying to tackle it. With help from Microsoft we've deleted a lot of the data directly using SQL. However, I now want to keep on top of the maintenance. I've tried to run the database log clean up job with (DateRange(-30,-0)) to delete anything older than 30 days but it doesn't appear to work, I've only had success when explicitly specifying a date, which I don't want to do if I'm scheduling a recurring batch job.

Any tips on setting up a recurring clean up job please?

Thanks,

Michael

I have the same question (0)

All responses (6)

Answers (3)

Verified answer

André Arnaud de Cal... 300,731 Super User 2025 Season 2 on at

Like (1)

Report

Hi Michael,

Can you explain the behavior when you mention "it doesn't appear to work"? Note that the date range is now set to the last 30 days, not older than 30 days. For older than 30 days, you can use the query syntax (LessThanDate(-30)).

Was this reply helpful? Yes No
Verified answer

Hana Xue Microsoft Employee on at

Like (2)

Report

Hi,
Please check your date range settings, you want to delete data that is more than 30 days in the past, please use the lessthan method.

Best Regards,
Hana

Was this reply helpful? Yes No
Bharani Preetham Pe... 3,634 Moderator on at

Like (3)

Report
Seems you are using wrong syntax to fetch dates older than 30 days. You should use this

Less than thirty days from now – Enter (LessThanDate(30)).

For more understanding, please check the link Advanced filtering and query syntax - Finance & Operations | Dynamics 365 | Microsoft Learn

Was this reply helpful? Yes No
Hana Xue Microsoft Employee on at

Like (0)

Report

Hi,

If the answer is helpful ,please mark it as verified to help more people in the forum.

Best Regards,

Hana

Was this reply helpful? Yes No
MBates237 211 on at

Like (0)

Report

Just an update on this one, I've run the cleanup job to delete everything older than a year

But it seems to have just deleted everything as there are now only records from today in the DB log (this is the view sorted by oldest to newest) Should it have been (LessThanDate(-365)) i.e. anything older than 1 year ago?

Was this reply helpful? Yes No
Verified answer

Bryan Sanderson 778 on at

Like (1)

Report

Yes, it should have been (LessThanDate(-365)). The query you ran was in essence saying anything older than 365 days from today, aka go a year from today and delete everything older than that.

Was this reply helpful? Yes No