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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / System Jobs in Dynamic...
Microsoft Dynamics CRM (Archived)

System Jobs in Dynamics 365 Field Service

(0) ShareShare
ReportReport
Posted on by antc 2,909

Hi all,

I have noticed that some of my Agreement Bookings Setup have failed. Looking at the System Process / Plugin a user made some changes to the Agreement Booking Setup of many records. That user is now the owner of these system processes which all failed due to delete permissions.

I have done an update of every record via SSIS however it doesn't start a new process.

I have via GUI turned auto generate Workorder on and off with no success and have to open and save Booking Recurrence to start a new background process.

What would be the best way to touch these records preferably via SSIS update to get these system processes under the correct user running again.

Any thoughts on this being a bug or any way to change system processes to be run by system versus user?

*This post is locked for comments

I have the same question (0)
  • antc Profile Picture
    antc 2,909 on at

    Changing and updating a Booking Recurrence "msdyn_recurrencesettings" via SSIS works and restarts the two System Jobs required however I would prefer not to change all the records.

    Any ideas on how to restart the System Job: Field Service - Generate Agreement Booking Dates which then kicks off the Process: Field Service - Generate Work Order for Agreement Booking Date?

  • antc Profile Picture
    antc 2,909 on at

    I have tested running batch process to run System Job: Field Service - Generate Agreement Booking Dates and it works.

    Issue now is how do I fetch all records that don't have "System Job: Field Service - Generate Agreement Booking Dates" status reason as "waiting". The fetches I can come up with can return all "waiting" however when I try outer-link it returns all records.

    If I run it on all I then have two "System Job: Field Service - Generate Agreement Booking Dates" listed as "waiting" on records that are already waiting, will this cause issues when the first one runs?

    Would easiest solution be to cancel all "Field Service - Generate Agreement Booking Dates" system jobs then run the batch process on all AgreementBookingSetup records?

  • Verified answer
    antc Profile Picture
    antc 2,909 on at

    As expected MS Support can't provide an answer so I will need to pull the trigger on one of these two options as it's urgent to get back up the auto work order creation.

    Anyone have a preference on which option they would go with, I'm thinking B but have had issues before bulk cancelling jobs in CRMOL.

    A) Run it on all AgreementBookingSetups  then have two "Field Service - Generate Agreement Booking Dates" listed as "waiting" on records that are already waiting, will this cause issues when the first one runs?

    B) Cancel all "Field Service - Generate Agreement Booking Dates" system jobs then run the batch process on all AgreementBookingSetup records?

  • Verified answer
    MSCRM Guru Profile Picture
    MSCRM Guru 600 on at

    Hey,

    I would probably go with B if that's possible.  I would rather have one instance of the workflow waiting rather than have un-necessary duplicate instances that may cause issues.  Also, I've found so many bugs with the PSA module that I would think it is likely to either cause issues or double bookings.

    You can use XrmToolbox to execute the workflow against all records in a FetchXML query, but cancelling the waiting ones will need to be manual via the UI.

    Good luck!

  • antc Profile Picture
    antc 2,909 on at

    Cheers,

    Definitely Option B I think. I have Asynchronous Batch Process solution that helps perform rollups so will use that great tool. Love XRMToolbox use it all the time.

    Hopefully not to many bugs in PSA will be rolling that out this year. Too many bugs are written off as "by design" :(

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans