web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Supply chain | Supply Chain Management, Commerce / Work user session log ...
Supply chain | Supply Chain Management, Commerce
Suggested Answer

Work user session log cleanup ( need to retain 12 month data)

(0) ShareShare
ReportReport
Posted on by CU17101147-0 29
Hi 
 
I want to schedule Work user session log cleanup batch job in my environment and have to retain data for 12 months instead of hours. 
As we can see only /number of hours to keep/ field. Could you please suggest how to retain 12 months data and set batch job occurrence in every 12 months. 
 
 
 
Thanks
Ashish
I have the same question (0)
  • Suggested answer
    Kevin Xia Profile Picture
    Kevin Xia Microsoft Employee on at
    Hi,
    If you want to retain data for 12 months instead, you may need to take a different approach. Here are steps to achieve this:
    Custom Job:
    • Create a custom cleanup job that runs on a scheduled basis, targeting the work user session log tables.
    • This job should be designed to identify and delete records older than 12 months.
    Data Management Workspace:
    • Utilize the Data Management workspace to create and schedule data projects that delete the records from the work user session log tables.
    • Configure the data project to filter records based on the timestamp to retain only the last 12 months' worth of data.
    Custom Batch Job Recurrence:
    • If you specifically need a batch job occurrence every 12 months, you may need to implement a custom recurrence pattern.
    • This could involve creating a recurring batch job that runs a cleanup job every 12 months. You may need to use a combination of job recurrence configuration and custom logic to achieve this.
    Best regards,
    Kevin

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
Mallesh Deshapaga Profile Picture

Mallesh Deshapaga 1,070

#2
Laurens vd Tang Profile Picture

Laurens vd Tang 238 Super User 2026 Season 1

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 131 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Quality order uses default receipt location instead of actual physical receipt location

Product updates

Dynamics 365 release plans