Desktop productivity for business analysts and programmers

SAS EG job - Automation

Reply
New Contributor
Posts: 3

SAS EG job - Automation

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?

Super User
Posts: 6,927

Re: SAS EG job - Automation

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
New Contributor
Posts: 3

Re: SAS EG job - Automation

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?
Frequent Contributor
Posts: 83

Re: SAS EG job - Automation

As @KurtBremser 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 ?

New Contributor
Posts: 3

Re: SAS EG job - Automation

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.  

Frequent Contributor
Posts: 83

Re: SAS EG job - Automation

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

 

Else maybe FTP ?

Frequent Contributor
Posts: 83

Re: SAS EG job - Automation

ConnectSmiley Very Happyirect  should read Connect : Direct

 

Frequent Contributor
Posts: 83

Re: SAS EG job - Automation

OR

 

Map a UNIX path to a Windows file share with Samba

 

OR

 

Install a SAS PC file server on your Windows server

 

 

Super User
Posts: 6,927

Re: SAS EG job - Automation

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Ask a Question
Discussion stats
  • 8 replies
  • 154 views
  • 0 likes
  • 3 in conversation