BookmarkSubscribeRSS Feed
ruanmet
Calcite | Level 5

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:

ScreenHunter_01 Sep. 15 11.47.gif

 

 

The command works fine from command line in Putty, using the sassrv user, as per the below:

ScreenHunter_06 Sep. 15 12.03.gif

 

But I get the /usr/bin/ksh: bjobs:  not found. error when running from E-Guide. 

ScreenHunter_03 Sep. 15 11.49.gif

 

The B commands are in /EIP/Software/Platform/lsf/9.1/aix-64/bin, and not in /usr/bin/ksh. 

ScreenHunter_05 Sep. 15 11.50.gif

 

ScreenHunter_04 Sep. 15 11.49.gif 

 

 

 

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

 

 

 

 

 

 

 

 

 

2 REPLIES 2
ballardw
Super User

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.

ruanmet
Calcite | Level 5

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;

sas-innovate-2024.png

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.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 554 views
  • 0 likes
  • 2 in conversation