The last in the list of SharePoint quirks happened to me few days ago.
You have a SharePoint Designer workflow that has a Pause Workflow action until some future date. The date arrives and the workflow doesn’t wake up.
The First Thought
Timer activities in SharePoint workflows were prone to keep sleeping when rehydrated. A fix was promptly released by Microsoft, available here (as I mentioned in this blog).
The Real Culprit
For some obscure reason the SharePoint timer job that wakes up the sleeping workflows got lost. It was not activated. To check this up, fire the CMD window and type:
stsadm -o getproperty -propertyname "job-worfklow" -url http://MOSS_SERVER_URL
in this case it returned
<Property Exist="No" />
just as I feared.
stsadm -o setproperty -propertyname "job-worfklow" -propertyvalue "every 1 minutes between 0 and 59" -url http://MOSS_SERVER_URL
Paul Galvin’s blog (http://paulgalvin.spaces.live.com/blog/cns!1CC1EDB3DAA9B8AA!198.entry)
El Blanco’s blog (http://chrissyblanco.blogspot.com/2007/06/issues-with-delay-activity-in-moss.html)