Viewing run log of a scheduled EG script

[Djones4822]

I have an EG script that I've scheduled to run every night.

The other night, one of the source tables was removed by a user causing the EG script to fail. I did not realize this until I had opened the report in VA. 

Is there a way to get outputs of the runlog? Specifically, I would love a log that states the step, whether it was successful or not, and if not the accompanying error log. Ideally, I would like this saved somewhere after every run

Is that possible? 

[Kurt_Bremser]

Save the code to a .sas program file, and run that from the scheduler with the sasbatch.bat or sasbatch.sh. Add a -log option, and check for the return code.

[Djones4822]

I'm not sure this would work for me as we don't have a local SAS executable installed on my machine. I was under the impression that EG worked because it connects to the host machine where the code is executed. 

Am I mistaken? Is there some way for me to execute sas code from my machine? 

[SASKiwi]

I suspect EG processes on a remote SAS server in your case. If so, then I would highly recommend checking out SAS Management Console and its scheduling capabilities. If you aren't familiar with SMC I suggest you talk to your SAS administrator about scheduling using SMC. It is way more reliable than EG for scheduling and it creates log and output files automatically.

[Kurt_Bremser]

---

@Djones4822 wrote:

I'm not sure this would work for me as we don't have a local SAS executable installed on my machine. I was under the impression that EG worked because it connects to the host machine where the code is executed. 

Am I mistaken? Is there some way for me to execute sas code from my machine? 

---

Save the code to the server and schedule it there. Either use SMC and SAS built-in scheduling, or use your company-wide scheduling system (preferred, if one exists).