topic viewing log/results in EG of jobs submitted to grid in SAS Enterprise Guide

viewing log/results in EG of jobs submitted to grid

larnzsword — Thu, 02 Nov 2017 19:31:49 GMT

is there way to view in EG the status of a SAS job submitted to the Grid ? the local log and output window are not returned/displayed. one can't tell if job completed or not or if errors encountered.

Re: viewing log/results in EG of jobs submitted to grid

george_georgiou — Tue, 14 Nov 2017 15:02:52 GMT

The SAS log should actually return any errors/warnings and even tell you on which node in the Grid. What version of SAS EG are you running?

Re: viewing log/results in EG of jobs submitted to grid

larnzsword — Thu, 16 Nov 2017 20:15:44 GMT

SAS version: 9.04.01M4P110916

EG version: 7.12 (7.100.2.3350) (32-bit)

Re: viewing log/results in EG of jobs submitted to grid

Babloo — Fri, 17 Nov 2017 06:31:16 GMT

How to find in the log to know in which node the job has failed?

Re: viewing log/results in EG of jobs submitted to grid

JuanS_OCS — Fri, 17 Nov 2017 08:26:54 GMT

Hello @larnzsword,

I don't think sas EG is the best tool for that. However, there are tools out there that will help with that question and many others (as performance, monitoring, killing sessions, etc). My favourite is the Enterprise Session Monitor (aka ESM provided by Boemska.

You can find more information at

https://boemskats.com/esm/

https://communities.sas.com/t5/Administration-and-Deployment/dash-board-to-monitor-all-the-running-jobs/td-p/301320

And I am sure @boemskats can provide you more information.

Hope it helps.

Kind regards,

Juan

Re: viewing log/results in EG of jobs submitted to grid

larnzsword — Fri, 17 Nov 2017 14:01:59 GMT

@george_georgiou, @JuanS_OCS, @Babloo

thanks all for you replies.

just wondering why my SAS code submitted to the Grid does not return anything either the log or output. something to do with our SAS setup ? SAS tutorial using EG shows log results displayed after code submitted to the Grid. hope someone can explain what's going on.

Re: viewing log/results in EG of jobs submitted to grid

george_georgiou — Fri, 17 Nov 2017 14:14:54 GMT

You might actually have the option turned off inside the EG options.

Try this and let me know if you get your SAS log:

Open SAS Enterprise Guide > go to Tools > Options > Results > Results General > make sure the option "Show generated wrapper code" is checked.

Re: viewing log/results in EG of jobs submitted to grid

larnzsword — Fri, 17 Nov 2017 14:16:18 GMT

thanks. going to try it and report it here.

Re: viewing log/results in EG of jobs submitted to grid

larnzsword — Fri, 17 Nov 2017 18:09:29 GMT

@george_georgiou

My settings are fine.

I may have misstated about LOG part. I got something in the log:

NOTE: Remote signon to GRID1 complete.

35 rsubmit grid1 persist=no;

5 The SAS System 12:44 Friday, November 17, 2017

NOTE: Background remote submit to GRID1 in progress.

However, query results were not returned back to EG.

Here is SAS code (copied from SAS tutorial) submitted:

%let jnvar = lte_2017c;

%let rc=%sysfunc(GRDSVC_ENABLE(_ALL_,SERVER=SASApp; jobname=jnvar));

signon grid1 connectwait=no;

rsubmit grid1 persist=no ;

MY SAS CODE

endrsumit;

And that's it.

That's it.