Hello everyone,
Recently I have encountered one issue in Time-dependent workflow action. I have observed that records are sitting ideally in the workflow queue as a pending action with scheduled date in past.
That means if today is 16th April 2021, I can see records in pending action queue with scheduled date in March 2021 or even in Feb 2021.
Normally if a pending action is not executed on scheduled date it should reschedule to future date. This is quite strange issue to me.
After so much investigation what I found is the issue is in record volume. As per workflow limits, per hour workflow can execute 1,000 records by default. So, if there are millions of records are sitting in workflow queue then Workflow just loose its mind 😀 .
Ref: Workflow Limits

If possible optimize your workflow to consider less volume of record but I don’t think that’s going to be an option with many business cases.
To solve this issue, you can either move your logic to batch class and schedule the batch to run everyday or you can contact Salesforce team to increase the limit.
If this post helped you to save your time and solved your problem then don’t forget to like and share this article with your friends.
Happy Learning! 🙂
-JP

