Hi @helannivas88
We collect various information from grid servers, but iInstead of executing the linux command from SAS, we have split the process, so each server writes its own information to a file, and the files are later read into SAS.
We have identical sh-scripts on all servers that writes results to files in a folder on the shared file system. On each server a crontab entry is added to schedule the script, and the result is a file per command per server. The files are named so command and server is easily identified.
Then we have SAS jobs, one per command, that read the output files from all servers. The SAS jobs are run in our data warehouse batch scheduled to start after all linux commands are executed, and each job reads files of a given type from all servers, add server name from the filename as a source variable and append o a permanent SAS dataset.
You must have authorization to do the Linux work yourself or be on good terms with your server staff. I would recommend to leave it to them if possible, because they will have to sort it out anyway, if something doesn't work, like your SAS batch account not having the proper permissions to run the script or the script not having permisssions to write to the shared file system. But we never had any trouble with that.
... View more