I need scheduled script (once per day) that will export all data to SQL table. This SQL table is source for additional requirements (web source, further analysis, etc.).
I have tried to make it successful via FileMaker Server, but it seems that server can schedule only 'web compatible' scripts. And those scripts are only for some operations in database, but not for ANY kind of export or manipulation with external databases. I don't know why exists this limitations...
Scheduling of scripts was main reason for using a new server version, but now it was worthless investment...
Does anybody knows how to trigger (or schedule) a script that can execute SQL at specific time?
Any help would be appreciated!