sas dis - Referencing job path and name in SAS DIS -
in sas dis, want reference job name in code. know global variable etls_jobname
contains information, when assign value field , view output, '.'.
ultimately, i'd able path name (in folder structure of job) , i'm not sure sort of information lives.
much gratitude.
for job flow metadata path, can try using below code. code picks job name &etls_jobname macro variable , extracts metadata folder path of job. know more functions being used, please refer sas language interfaces metadata. hope helps!
data path_output; length jobname $ 100 uri headuri $ 256 jobpath head_path $ 500 ; jobname="&etls_jobname"; rcjob =metadata_getnobj("omsobj:job?@name ='&etls_jobname'",1,uri); rchead=metadata_getnasn(uri,"trees",1,headuri); rcpath=metadata_getattr(headuri,"name",jobpath); rchead = 1; while(rchead>0); rchead=metadata_getnasn(headuri,"parenttree",1,headuri); rcpath=metadata_getattr(headuri,"name",head_path); if (rchead>0) jobpath = catx('/',head_path,jobpath); end; output; keep jobname jobpath; run; proc print; run;
update:
if job flow uri needs picked based on job flow name use show in code above i.e.:
rcjob =metadata_getnobj("omsobj:job?@name ='&etls_jobname'",1,uri);
if job flow uri needs picked based on metadata id use :
rcjob =metadata_getnobj("omsobj:job?@id ='&jobid'",1,uri);
Comments
Post a Comment