SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Viewing run log of a scheduled EG script

Reply
Contributor
Posts: 28

Viewing run log of a scheduled EG script

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? 

Super User
Posts: 9,914

Re: Viewing run log of a scheduled EG script

Posted in reply to Djones4822

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Contributor
Posts: 28

Re: Viewing run log of a scheduled EG script

Posted in reply to KurtBremser

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? 

Super User
Posts: 3,860

Re: Viewing run log of a scheduled EG script

Posted in reply to Djones4822

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.

Super User
Posts: 9,914

Re: Viewing run log of a scheduled EG script

Posted in reply to Djones4822

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

 

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Ask a Question
Discussion stats
  • 4 replies
  • 181 views
  • 2 likes
  • 3 in conversation