Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

Workflow cleanup

Posted on by 185

Hi Folks,

Today, I was looking into my system jobs(Worklflow)and found that there are 100K + of them in waiting status reason. The reason being the user who created workflow is now inactive. Is there anyway to run this jobs on a schedule basis. I had this similar issue previously it was Onprem able to fix. But this time its online.

Please let me know if there us any workaround.  

Thanks and Regards

Ravi. B

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Workflow cleanup

    Hi Ravi,

    if you solved the problem thanks to an answer, please mark it as verified to encourage the community to provide more and more a better support. Thank you. Francesco

    If you found the answer helpful, please mark as Verified 

    Join my network on LinkedIn      Follow me on Twitter 

    Thank You & Best Regards

    Francesco Picchi

    Microsoft Dynamics CRM Consultant, Bologna+Milano, ITALY

    Independent Contractor

    http://www.francescopicchi.com

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Workflow cleanup

    Hi Ravi,

    you should persuade your client to reactivate the user, eventually modifying his role to avoid any unwanted update over excluded entities.

    Then proceed as shown.

    Please let me know.

    If you found the answer helpful, please mark as Verified 

    Join my network on LinkedIn      Follow me on Twitter 

    Thank You & Best Regards

    Francesco Picchi

    Microsoft Dynamics CRM Consultant, Bologna+Milano, ITALY

    Independent Contractor

    http://www.francescopicchi.com

  • ravibachanagiri Profile Picture
    ravibachanagiri 185 on at
    RE: Workflow cleanup

    Hi Francesco,

    Thanks for the reply. I knew this process and implemented in the past but my current client doesn't want to activate the user also there are around 100K jobs in waiting state and I don't think this solves my problem. If there are very few records then I can proceed as said above, but not for such huge number of records as I have. 

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Workflow cleanup

    Hi Ravi,

    if the problem is the user is inactive, you have to:

    1) deactivate workflow

    2) assign to crm admin o active user

    3) reactivate it

    Then:

    1) if you cant delete all old jobs, reactivate temporarly the user

    2) otherwise delete them

    Please let me know.

    If you found the answer helpful, please mark as Verified 

    Join my network on LinkedIn      Follow me on Twitter 

    Thank You & Best Regards

    Francesco Picchi

    Microsoft Dynamics CRM Consultant, Bologna+Milano, ITALY

    Independent Contractor

    http://www.francescopicchi.com

  • ravibachanagiri Profile Picture
    ravibachanagiri 185 on at
    RE: Workflow cleanup

    Hi Francesco,

    Thank you for the reply. I was trying to resume my workflow not to delete them.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Workflow cleanup

    Hi Ravi,

    please refer to:

    crmtipoftheday.com/.../scheduling-daily-bulk-delete-jobs

    Hope it helps!

    If you found the answer helpful, please mark as Verified 

    Join my network on LinkedIn      Follow me on Twitter 

    Thank You & Best Regards

    Francesco Picchi

    Microsoft Dynamics CRM Consultant, Bologna+Milano, ITALY

    Independent Contractor

    http://www.francescopicchi.com

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans