Scheduled scripts and external databases

[brian rich]

We are running FMS 11 Server advanced and also run a 'robot' FMP 11 Client on a separate computer on the network, whose job is to assemble a certain data set overnight from databases on the Filemaker server - this dataset is used for personnel scheduling.

A Planning database on the server references the robot's scheduling data and updates it's own dataset. The script in the Planning database that runs the update calls several scripts in the robot client. This script works correctly when run locally from a client.

We set up a schedule on the server to run the update script in the Planning database but it does not appear to work. Using the 'Show Compatibility' box on the update script does not show the Perform Script steps which refer to the external database as incompatible.

Are server side scripts able to call scripts in remote databases?

Thanks

Brian

[supernatural]

Page 133 in fms11_help.pdf

"A server-side FileMaker script that is running on one FileMaker server cannot open a database that is hosted on a different FileMaker server."

[brian rich]

Thanks @supernatural

That was it - looked at the log files and the Perform Script steps to the external files were giving error 100 (file not found)

Brian