01-04-2018 11:55 AM
I am new to SAS. And we use SAS EG to connect to a SAS UNIX server.
There are so many processes that are manually run every day and results are exported to a windows shared drive manually.
The requirement is to automate and schedule the processes.
What are the options to do so? Please let me know if more details are needed.
01-04-2018 11:57 AM
01-04-2018 03:12 PM
Since your SAS jobs are running on a UNIX server, I recommend you use your Unix scheduling (cron, scripts) capabilities or one of the SAS server-side products to schedule production jobs.
Enterprise Guide is a great tool, but I don't feel it's the best for scheduling production jobs on a remote server, as there are too many moving pieces (your machine, the network, and finally your SAS server). If any of these is having issues, it can interfere with your job executing correctly.
Use EG to develop and test your code, and for exploratory data analysis. Once you have your SAS programs going the way they should be, put them on the server and schedule them there.
If you search this site, you'll find a lot of posts that recommend this, in response to people who are experiencing problems using the EG scheduling facilities.
01-08-2018 12:32 PM
As a first attempt to schedule, I used the Enterprise Scheduler and created a schedule, which actually created a Windows task.
But it failed to run with the error below:
Logon Failure: the user has not been granted the requested logon type at this computer. (0x80070569)
What could be the issue?
And also, the SAS server is UNIX and SAS EG is on a Virtual Desktop, like a mentioned before, what are some of the challenges using the SAS EG scheduler which creates jobs on a virtual computer that I logon to run processes on the UNIX server. The processes I run create access and excel outputs which need to be saved on Windows shared drives and share point destinations.