I've created a task list with a retention policy that runs a workflow on due date. the workflow is just 1 single action to send an email to the person assigned to. If I manually start the workflow it does send the email. However for all other tasks the users are not getting any email that is supposed to be sent by the retention policy on due date. Any Ideas why? I am using Sharepoint foundation that is included in Office 365 subscription. Te workflow is 2010
There are 2 timer jobs in SharePoint that manage the Information Management policy. Expiration Policy timer job, which determines which items are expired based on rules, and Information Management Policy, which actions the expired items by running the rules. These jobs are run weekly by default. In SharePoint on premise you can manage how these jobs are run, but unfortunately you cannot do that in SharePoint Online.
In your case I believe, most likely you have to wait a maximum of two weeks for the email to be sent. To check when the timer jobs were run last connect to the SharePoint online site using SharePoint Designer. On the home page click on Site Options in the top ribbon. then check the following two properties:
which mention when each job was run last time and wait for them to run next and hope the email is sent :)
From what I understand from your business requirement, you might want to consider not using the information management policy at all, and handle the wait operation in your workflow using the workflow action "Pause until date" and set the due date.