Running scripts with Execute SQL command from script scheduler in FMS 9
We have just upgraded from FMS 8 to FMS 9, partially for the script scheduler. We were excited about having a more reliable tool than the plug in we were using with FMS 8. I now see that I cannot use the script scheduler, because all of my scripts use the Execute SQL command to communicate with our other databases, and that script step is not web enabled (and FMS 9's scheduling tool only supports web enabled script steps).
Now I am looking for a work around. Does anyone have any suggestions? How can I, on a daily schedule, update my SQL databases from FMP, without using a plug in on one of of clients?