Hello @JohnJPS,
here my ideas to you:
1- Easiest, but might require additional SAS license: to make use of SAS/CONNECT if you do have it on both environments.
2- Create a scheduled task (local, in source environment) that runs every X time and checks for an empty file. If present, executes the export and places results in a shared folder (to the destination environment), of course deleting that empty file once the process is finished.
3- Use remote commands such as sysinternal tools if you are in Windows, or ssh if you are in Linux.
4- A funny but interesting option: create a stored process and convert the stored process into a Web service, what would allow you to call it with normal HTTP request (soap, json) or rest API.
The trick is to create as small and simple components as possible, with easy communications/interfaces too. 🙂