Solution that needs to run a process every day?

Discussion created by jjfcpa on Jun 13, 2017
Latest reply on Jun 13, 2017 by fmpdude

I have created a solution for my employees to submit vacation requests.  When they submit new requests, it will send me an email and I can then approve or deny the vacation request from within the same solution.


I thought it would be a nice feature to email all employees each week and let them know who will be on vacation the following week.


I need an application that will run a process every day at a certain time to check for approved vacation requests and send the emails to the employees. 


My Vacation Request solution is running on Filemaker Server so I was thinking I could install a copy of Filemaker on the server and have it running a solution that would open the Vacation Requests solution and check for vacations the next week.  Is this the right approach?