I have a database that performs loads of calculations. The results need to be accessible over a WAN, so I run a scheduled script to perform the calculations and store the results, which is normally fine. However, sometimes the user wants to recalculate the results so they are completely up to date.
If I use the script step Perform Script on the local machine to start the script running in the hosted file it seems to then perform the processing on the local machine with all the bandwidth baggage that goes with it.
Is it possible to trigger the scheduled script remotely so that it is is stil the server performing the calculations? I was wondering if it's possible to call a URL on the server that starts the script running so I can trigger it from a button in Filemaker? Ideally, I could do with it working from Filemaker Go & Pro.
Has anyone got any experience/success in doing this?
Thanks in advance.