DSXchange

Hi
I am using below command to retrieve the parameter values passed during a job run. I need to collect this information for all jobs in project across multiple servers.

dsjob -logsum <project> <jobname> | grep STARTED | tail -2 | head -1 | tr '\t' '|' | cut -d"|" -f1 | xargs dsjob -logdetail <project> <jobname> | tr '\t' ' ' | grep " = " | tr '^' ' ' >/tmp/outt


Issue is: It gets hanging if the log has too many entries like warnings/errors and does not return.

Is there any way to get the parameter values passed during a job run using dsjob commands.

Thanks

Have you looked into "dsjob -jobinfo"? I think it will have that for the most recent job run, if that's what you are after. Or perhaps "-lparams" or a variant thereof.

I tried both of these options but in vain.

-jobinfo does not give current parameters passed.
-lparams and -paraminfo gives only default parameters stored. Not the current prameters.

You can get this information using the DSGetParamInfo() function, are you sure you need to do this from a script rather than from job control?

Yes. I would need to do it from script.

OK, then it looks like you'll need to read the logs for that. How long did you wait before you decided it was 'hanging'? Why not use the -type STARTED option rather grepping through everything for them?

You can run EtlStats on a running job and it will retrieve parameter values too.

I was waiting for more than 1 hour or even more in some instances.

-type STARTED -max <n> helped a lot. It's faster now.

Thanks a lot for your help, Craig !

Resolution Fix:

dsjob -logsum -type STARTED -max <n> <project> <jobname> | tail -2 | head -1 | tr '\t' '|' | cut -d"|" -f1 | xargs dsjob -logdetail <project> <jobname> | tr '\t' ' ' | grep " = " | tr '^' ' ' >/tmp/outt