Hi @Martin_Bryant
if you were to adopt the Stored Process approach suggested by @Sajid01 , which is a good approach, here are few things to be aware of
- Program permissions
- Output permissions
Depending on which execution server (Stored Process Server / Workspace Server) you pick for your Stored Process program, the Read/Write permissions may need to be examined and changed. STP Server would execute the program using the sassrv service account, while Workspace Server would use your userID, as if you are running it interactively via EG.
Hope this helps,
Ahmed
... View more