Dsjob cmd to retrieve Job annotation, Job Short/longdescrptn

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
senthilt1
Participant
Posts: 134
Joined: Mon Nov 19, 2007 2:17 am

Dsjob cmd to retrieve Job annotation, Job Short/longdescrptn

Post by senthilt1 »

Hi Friends,

I would like to know how to retrieve the Job Annotation and Job Description using dsjob command. I have around 500 jobs ..I need to validate whether the job annotation and job description is missing in any of the job.

I tried with all the commands in Dsjob, but i could not get the above detail.

Kindly help me out and suggest if there are any other options for the same.

Thanks in Advance!!!

-Senthil
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

There is no option within the dsjob.exe calls that will give you that information.
There is no simple way to do this, but perhaps doing an export into XML format and then parsing that file for the short and long descriptions is the easiest way.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Does the 'job report' that one can generate from the command line contain this information? Is it in a format that can be parsed out / detected?
-craig

"You can never have too many knives" -- Logan Nine Fingers
kduke
Charter Member
Charter Member
Posts: 5227
Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:

Post by kduke »

You could get in the html document. If that is what Criag is talking about. When you generate job documentation.

You could get it in SQL.
Mamu Kim
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Craig's not really sure what he's talking about, hence the plethora of question marks. :wink:

With no way to test anything, just trying to point the OP in a (possibly) helpful direction. Thanks for the clarification!
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply