I have a scheduled workflow that iterates through a number of document libraries and creates a summary email of documents created for that day for each user that has created documents. The workflow is scheduled to run daily, during a large query window, beginning at 9:05 PM. On some days the workflow runs with no issues on those days the workflow starts as expected at 9:05 PM. However on other days the workflow begins about 30 minutes late and seems to start over and sends out the summary emails twice.
The logs indicate that the workflow only ran once but the steps of the workflow seem to start over again from the beginning after the final loop completes. This is despite a stop workflow step that is being reached.
The workflow is rather long so a screen shot is problematic however here is the gist:
- Call lists web service to retrieve a collection of document libraries
- For Each List get a collection of users that created documents on that day
- For Each User iterate the lists and build an email of documents
- End Workflow
Is the workflow being run from both web front ends?