I hope this is posted in the correct forum.
I have a Windows 2008R2 web server that runs MySQL. I need to execute a SQL script against the mysql database to create a CSV file, and save to a defined location on the disk within one of my websites. A third party will then, via FTP, connect with their own set of credentials and download this file at a set time once a day.
What I am stumped about decision wise is the most reliable way to make sure the SQL script has executed and the file is on the disk ready for the timed once daily collection.
What is the most reliable - Task scheduler running a .aspx script or calling an EXE (I have had issues in the past with Task Schedulers reliability), an EXE that runs all the time and one a timer once a day prior to 3rd party FTP collection makes sure the CSV file is there, or can anyone suggest a much better way?