Is it my understanding that in order to run a PSOS, the script must be in a file located on the server? Similar to the way you would run a script setup on FMS as a Scheduled Activity script?
Yes. Otherwise how would the server scripting engine have access to the script?
The script will be run from FMGO and the solution is hosted on FMS, so the script is essentially on FMS but it's in the hosted file. I just didn't realize that the solution has to be on the server machine, opened, and the script run from it.
If the solution is hosted by FMS, you can execute Perform Script On Server script step on any client machine and the script will run on the server.
Not sure what you mean "the solution has to be on the server machine, opened, and the script run from it", because if it's hosted, it is by necessity "on" the server machine and "open". I think you might be confused about what being "open" on the server means? If clients can connect, it's open.
If you're thinking you need to open the solution in FMP or FMPA on the server box, you are mistaken.
Retrieving data ...