Hi,
In LSF scheduler I have 15 jobs in one flow I need all jobs statistics in one table for client view like Job name, Start time, End time, Total time, Status. Is any option in LSF to get all statistics in single view. pls help me bit urgent.
I don't know about LSF, but if you are using LSF in conjunction with DI Studio, there are plenty of tools for generate code that logs job execution.
A part from the documentation, there is a quite fresh thread on the matter:
https://communities.sas.com/message/194606#194606
Hi We have created 2 small sas scripts and added them in sasbatch.sh.
These get the flowname, jobname, flowid and job id from the unix environment.
The first call has 0 as returncode, the second run takes the returncode from the real sas job.
In the sasscripts, the environment variables are sent to a table, which is the basis for all sorts or reporting.
With naming conventions you can build a framework.
Code to get the commandline of the flow-job-subjob:
%let host = %sysget(HOST);
%let jobid = %sysget(LSB_JOBID) ;
%let v_flow_job = %sysget(LSB_JOBNAME);
%put v_flow_job = "&v_flow_job";
%let ljob_rc= &sysparm;
%put &sysparm;
ljob_rc= "&ljob_rc";
host = "&host";
jobid = "&jobid" ;
jobfullname = "&v_flow_job" ;
flowid=left(scan("&v_flow_job",1,':'));
user=left(scan("&v_flow_job",2,":"));
flowname=left(scan("&v_flow_job",3,':'));
jobname=left(scan("&v_flow_job",4,':'));
jobsubname=left(scan("&v_flow_job",5,':'));
ldatetime=datetime();
Some of these are only available when a job is scheduled: with the LSB prefix.
sysparm is to get the returncode.
Regards,
BTW: our missing link is getting the scheduled time in, probalby from metadata.
Do you have RTM implemented in your servers?
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.