topic Re: Viewing run log of a scheduled EG script in SAS Data Management

Viewing run log of a scheduled EG script

Djones4822 — Mon, 19 Mar 2018 19:13:21 GMT

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?

Re: Viewing run log of a scheduled EG script

Kurt_Bremser — Mon, 19 Mar 2018 19:27:54 GMT

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.

Re: Viewing run log of a scheduled EG script

Djones4822 — Mon, 19 Mar 2018 19:47:53 GMT

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?

Re: Viewing run log of a scheduled EG script

SASKiwi — Mon, 19 Mar 2018 22:32:26 GMT

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.

Re: Viewing run log of a scheduled EG script

Kurt_Bremser — Tue, 20 Mar 2018 06:19:15 GMT

@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).