Greetings all
I am having a problem running Platform B commands from Enterprise Guide.
What I am trying to do is execute one of the B commands (bjobs) from enterprise guide, and piping the results to a dataset, using the below code:
The command works fine from command line in Putty, using the sassrv user, as per the below:
But I get the /usr/bin/ksh: bjobs: not found. error when running from E-Guide.
The B commands are in /EIP/Software/Platform/lsf/9.1/aix-64/bin, and not in /usr/bin/ksh.
The reason behind all this is that we want to automate the some of the b commands to have better visibility on what is happening with out ETLs, to manage our environment resources better
Here is the E-Guide log
25 GOPTIONS ACCESSIBLE;
26 filename jobinfo pipe "bjobs";
27
28 data getinfo;
29 infile jobinfo pad missover lrecl=3000;
30 input inline $1-500;
31 run;
NOTE: The infile JOBINFO is:
Pipe command="bjobs"
NOTE: 1 record was read from the infile JOBINFO.
The minimum record length was 32.
The maximum record length was 32.
NOTE: The data set WORK.GETINFO has 1 observations and 1 variables.
NOTE: Compressing data set WORK.GETINFO increased size by 100.00 percent.
Compressed is 2 pages; un-compressed would require 1 pages.
NOTE: DATA statement used (Total process time):
real time 0.19 seconds
cpu time 0.00 seconds
32
33 GOPTIONS NOACCESSIBLE;
34 %LET _CLIENTTASKLABEL=;
35 %LET _CLIENTPROCESSFLOWNAME=;
36 %LET _CLIENTPROJECTPATH=;
37 %LET _CLIENTPROJECTPATHHOST=;
38 %LET _CLIENTPROJECTNAME=;
39 %LET _SASPROGRAMFILE=;
40 %LET _SASPROGRAMFILEHOST=;
41
42 ;*';*";*/;quit;run;
2 The SAS System 11:07 Friday, September 15, 2017
43 ODS _ALL_ CLOSE;
44
45
46 QUIT; RUN;
47
Thanks
Ruan
Sometimes providing full paths to external sources help.
I suspect that the /usr/bin is where the SAS server (?) code sets and without a path to the desired objects that is where it defaults to looking for things.
Hi
I have tried using the full paths, and the results are still the same.
It creates the output file, but it is empty.
I have even specified the location of the profilels file
data _null_;
x "/EIP/Software/Platform/lsf/conf/profile.lsf; lsid > /EIP/Data/Lev1/Data/ACE_ADM/SourceFiles/bacct_out.txt";
run;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.