Running script steps on the Server
I would like to run a FileMaker script on the server (running Windows Server 2008 R2) that performs an SQL query every night and downloads the appointment records for the next day in to the appropriate table. I have some questions:
1. Do I have to have a copy of FileMaker Pro on the server machine to do this?
2. I have added the appropriate Data Source via the ODBC on the server machine - is that sufficient?