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 :
Microsoft Dynamics CRM (Archived)

Do we need MSCRM_Config.SiteWideCleanup?

(0) ShareShare
ReportReport
Posted on by

Hello CRM Experts,

Do we need to run MSCRM_Config.SiteWideCleanup in the SQL server? What are the possible impacts if this job is not run?

thank you!

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    on at

    crm job will take care for every day at 12:30. so no need to run manually.

    no impact, it will delete one day notification from the current date & time

  • Resh Profile Picture
    on at

    We have stopped the job SiteWideCleanup from running. I would like to know if there will be any impacts may be 2 or 3 months from now.

  • Suggested answer
    Community Member Profile Picture
    on at

    yes it is impact, MSCRM_Config database will get bigger and slower performance. it will "notifications" millions of records in the table.

  • Community Member Profile Picture
    on at

    please verify answer if it helped you.

  • Resh Profile Picture
    on at

    Why would a million record in Notification table affect performance as this just stores cache information and nothing else? What are the visible issues we can see and identify?

  • Suggested answer
    Community Member Profile Picture
    on at

    CRM service will look notification and will do the process, let us assume if you get every 100 notifications, end of month it will be 3000, p_CleanupSiteWideNotifications stored procedure will delete the notifications, so no notifications, crm service can't do any work. if not clean, it will try to do some work, your performance will be slow.

  • Resh Profile Picture
    on at

    Thanks. I agree to your point that if the cleanup is not performed, it causes performance issues. If the Notification table is not cleared, do you think cache invalidation will not be done and cache will increase? Will that cause buffer/procedure cache to increase and cause tempDB to grow?

  • Suggested answer
    Community Member Profile Picture
    on at

    yes it will cause the problem

    support.microsoft.com/.../en-us

    The Notifications table is not cleared. Therefore, an increase occurs in the size of the Notifications table in the MSCRM_CONFIG database.

    some example of the notification action for create/delete

    • Xrm.Page.ui.setFormNotification(message,level,uniqueId) – Sets the notification on top of the form.

    • Xrm.Page.ui.clearFormNotification() – Clears the form notification

    • Xrm.Page.getControl(“field_name”).setNotification(“Notification”) – Sets the notification for a specific field right next to the field label. This can often be used as a custom tool tip.

    • Xrm.Page.getControl(“new_name”).clearNotification() – Clears the notification

  • Resh Profile Picture
    on at

    Do you know if there is a KB article for the "Notification" issue mentioned in the UR10 changes?

  • Suggested answer
    Community Member Profile Picture
    on at

    that's the article from ms link i added my previous post.

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!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
JS-09031509-0 Profile Picture

JS-09031509-0 3

#2
AS-17030037-0 Profile Picture

AS-17030037-0 2

#2
Mark Eckert Profile Picture

Mark Eckert 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans