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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Suggested Answer

Do failed system jobs running slow down the system? How to tell if failed jobs are being re-run

(1) ShareShare
ReportReport
Posted on by 21
In this case I am specifically wondering about system jobs that run on the ms dynamics journeys app triggers.  We have several triggers that every time they are triggered the job fails.  We had a ton of failures today and our system slowed to a crawl.  I need to understand how failed jobs can potentially impact system performance.  We had 166 out of 1452 jobs fail today which doesn't seem like a higher percentage, unless those failed jobs are running over and over again for a period of time then entering failed status.
I have the same question (0)
  • Suggested answer
    PerezAguiar Profile Picture
    Microsoft Employee on at
    Hello!
     
    This is a very complicated question.  There's no direct relationship proven.  Usually, this will depend on the status of the job after execution.   Normally, failed jobs will remain in the list consuming storage.  As a safe practice, you should review failed jobs periodically and then, after solving any issue that might have caused them, remove them. 
     
    However, if we leave the number of records on certain tables to grow (ActivityPointer, etc), besides the extra storage, it means that everytime system requires something from this table, it will have more and more records to query. It's not the same to run a query over 200K records than doing it on 2 million.  Specially, because the larger the number of records the larger the indexes required.  And because there's a view of "failed system jobs", this will consume more storage and queries will be slightly slower.
     
    However, there are certain jobs that instead of being moved to "failed" remain as "waiting". And these are the dangerous ones, because it means they might be reprocessed.
     
    Regards,
     
    ******
    I hope this answer has helped you solve your problem. If you are satisfied with it, please consider marking it as the excellent answer by clicking on the green check mark below. This will help other users who have similar questions find the best solution.
     Thank you for your feedback!

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

News and Announcements

Season of Giving Solutions is Here!

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…

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
iampranjal Profile Picture

iampranjal 66

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 51 Super User 2025 Season 2

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 40 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans