topic Re: SAS EG job - Automation in SAS Enterprise Guide

SAS EG job - Automation

ykishorereddy — Tue, 18 Jul 2017 19:47:51 GMT

Hi, Seeking a help.

I have a scenario whether , set of SAS EG jobs are being executed manually by users and wanted to schedule them via 3rd party scheduler.

The SAS Server is on unix and SAS EG client installed on user machine , whether they execute the jobs, the reports output is stored in a windows sever.

Can you pls help me how this can be accomplished?

Re: SAS EG job - Automation

Kurt_Bremser — Tue, 18 Jul 2017 20:02:25 GMT

If you can run jobs on UNIX via the scheduler, I'd recommend making .sas files out of your jobs and running them in batch on UNIX.

Re: SAS EG job - Automation

ykishorereddy — Tue, 18 Jul 2017 20:08:03 GMT

Thanks for the update. actually, we are looking for no disruptions to current operations . currently, users execute EG from their local machine and report results are in windows servers. so they wanted to have similar fashion.

so, im thinking of this
1. Have a windows server with SAS EG client and Scheduler agents installed
2.Place SAS EG job on Windows server
3.Invoke SAS EG from scheduler this inturn invoke SAS server on linux

Pls help whether this is right approach?

Re: SAS EG job - Automation

nhvdwalt — Wed, 19 Jul 2017 06:09:05 GMT

As @Kurt_Bremser said, easier way is just to export the code as .sas and the run on the server as a batch job.

However, I suspect your question is more around the outputs to a Windows path. With EG on Windows, connecting to and sending output to a Windows path is easy, since it's all Windows. But I think your challenge is running SAS on UNIX and then writing to a Windows path...from UNIX. Is this correct ?

Re: SAS EG job - Automation

Kurt_Bremser — Wed, 19 Jul 2017 06:13:16 GMT

Personally, I would never involve Windows client software (EG) in production jobs that are scheduled. There are simply too many things in Windows that can break (.NET, VBS, ...)

In our setup, NO scheduling agents are needed on the UNIX server. All communication from and to the scheduler is done via ssh and sftp, and some custom shell scripts. Has been working like a charm for ~20 years.

Re: SAS EG job - Automation

ykishorereddy — Wed, 19 Jul 2017 13:14:37 GMT

Thats correct. currently, the report output is being written to windows and users want the same way. if i go with unix route, i would either have change SAS EG jobs to change the desntination path from windows to unix. thats reason, im thinking windows sever having SAS EG client as a middle layer for automation.

Re: SAS EG job - Automation

nhvdwalt — Wed, 19 Jul 2017 15:09:42 GMT

Do you have an enterprise file transfer utilty like XCOM or Connect:Direct ? You could then write to a UNIX directory and then have the utility move the file to a Windows directory.

Else maybe FTP ?

Re: SAS EG job - Automation

nhvdwalt — Wed, 19 Jul 2017 15:14:13 GMT

Connectirect should read Connect : Direct

Re: SAS EG job - Automation

nhvdwalt — Thu, 20 Jul 2017 03:58:09 GMT

Map a UNIX path to a Windows file share with Samba

Install a SAS PC file server on your Windows server