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;
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.