2

I want a workflow to run each day at 2.00 AM. Is there a way to achieve this? I found many posts but didn't work.

8

The OOTB way to do this would be to create your workflow as you want it and add a stage at the end. In this stage put in a Pause action. You can set this for 1 day (or 24 hours). For your Transition to stage, have it redirect back up to the first stage.

The downside of this would be that you have to manually start it that first time. It would also be one continuous workflow rather than it being ran separately once a day.

  • If I pause it for 24 hours, it will load after 24 hours and execute. Will it again pause for 24 hours? – Keerthi Apr 13 '15 at 19:36
  • Yes, it will keep looping until you cancel the workflow. If you want to test it out, I would suggest doing a 5 minute pause just so you can get a feel of what will happen and see for yourself without having to wait a full day. – Jordan Apr 13 '15 at 19:38
  • I paused it for 1 minute and started the workflow (starts when new item is created). It emailed after 1 minute but it stopped executing after that. The status of workflow changed to completed. – Keerthi Apr 13 '15 at 19:55
  • Put the pause at the end of the workflow and then point the transition to stage back to the first stage of your workflow. You should get the email right away, then have it pause, then receive another email after a minute. – Jordan Apr 13 '15 at 19:58
  • 2
    As far as I know, this solution will only work in a 2013 workflow. You would have to build your workflow using that platform. – Jordan Apr 13 '15 at 20:16
2

You can use a task scheduling tool such as SQL Server Agent or Windows Task Scheduler and have that execute a PowerShell script that start the workflow.

And here is a link to run the workflow in powershell: http://www.thesysadminhimself.com/2013/09/sharepoint-start-workflow-all-items-powershell.html

The only other option I can think of is somehow converting your workflow into a timer job but I don't really know how to do that.

..Hope this helps a bit.

  • I'm using SharePoint 2013 online. How to do a task scheduler fro this? – Keerthi Apr 13 '15 at 19:15
  • ahh.. good point.. so I guess this solution is not good for you then.. – Rubin Taipi Apr 13 '15 at 19:29
1

Do you mean Sharepoint online (as Sharepoint 2013 online does not exist)? For this task, i would recommand looking into Microsoft Flow that comes with Office 365 and can interact with Sharepoint Online list events and do executions like "wait until". Other solution is Azure webjobs trigger...

https://medium.com/@rjesh/microsoft-flow-pause-till-date-ecec207522d8

0

You can use PowerShell script. and schedule it with windows task scheduler.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.