I am creating a web app that requires a job scheduling function for intranet on a Windows server running Apache/PHP/MySQL. For now, we have been executing perl and PHP via .bat files using the built in Windows task scheduler. I would like the scheduling function to be more tightly embedded into the app and not have to utilize the Windows task scheduler. I am considering having a program written that would run as a service to manage the execution of the jobs (service would look at the jobs which would be defined and stored in a MySQL database).
Can anyone speak to this approach and recommend best way to accomplish this?