generate HTML report in datastage

qutesanju · Post by **qutesanju** » Wed Mar 18, 2009 4:12 am

hi,
how can i generate report for all datastage jobs kept in any folder?

right now i can generate report n designer FILE-->Generate Report
but for this I have to open each job in designer and then generate report for this

My question is that If in one folder there are 100 jobs then it's not feasible to open each and every job and then generate report.

at folder is it possible to generate report directly?

chulett · Post by **chulett** » Wed Mar 18, 2009 8:20 am

What's not feasible about it? It's just... tedious.

The dsjob command with the -report option does the same thing, from what I recall, so you could create a batch file to get a list of jobs and then loop through that list to create reports for all of them.

pneumalin · Post by **pneumalin** » Wed Mar 18, 2009 2:35 pm

dsjob -report only gnereates the job RUN report in BASIC|DETAIL|XML format, which is the Director Log Info. Regarding to job DESIGN report from Designer->File->Generate Report, I have not found out a way to create then in a systematical way. Appreciated if someone has done that and share with us...

chulett · Post by **chulett** » Wed Mar 18, 2009 2:46 pm

Ah... true. You need to use dsdesign.exe to get that HTML report, check this post for an example from Kim:

viewtopic.php?t=124036

pneumalin · Post by **pneumalin** » Fri Mar 20, 2009 10:58 am

Thanks for the sharing, and it did work. I also found the syntax in Page 227 Designer Guide.

qutesanju · Post by **qutesanju** » Thu Apr 02, 2009 1:55 am

pneumalin can u pls share exact command or syntax here?

chulett · Post by **chulett** » Thu Apr 02, 2009 7:20 am

Do you not have the pdf mentioned? Check the link I posted? Both places show the syntax.

vincentxy · Post by **vincentxy** » Sun May 24, 2009 10:06 pm

Here's how i did it. Just replace the italics part with your values.
Feel free to correct/comment. Thanks.

Step1: Get a list of all jobs and save it to a text file - joblist.txt
On datastage server: $DSHOME/bin/dsjob -ljobs project_name >~/joblist.txt

Step2: Ftp this file to your PC as the next command, dsdesign, is a client executable.

Step3: Write a simple dos patch program to loop through joblist.txt to generate the report like so.

for /F %%a in (joblist.txt) do dsdesign.exe /H=hostname /U=user_id /P=password project_name %%a /R /RP=report_destination_folder

kduke · Post by **kduke** » Sun May 24, 2009 10:55 pm

There is a batch file which will do this for you. It is on my tips page.

chulett · Post by **chulett** » Mon May 25, 2009 7:32 am

vincentxy - in 'later' versions of DataStage, dsjob is installed on the client side as well so that can cut down (by one) the number of steps needed.

vincentxy · Post by **vincentxy** » Tue May 26, 2009 3:54 am

Thanks for the info chulett. The version I am using is 7.5.1

kduke · Post by **kduke** » Tue May 26, 2009 7:19 am

Download the bat file. It does everything you want. It does dsjob to get a list of jobs then runs Designer on each job in a project. What else do you need?

chulett · Post by **chulett** » Tue May 26, 2009 7:32 am

how about a McCulloch chainsaw, a Las Vegas wedding, a Mexican divorce, a solid gold Kama Sutra coffee pot, or a baby's arm holding an apple?

kduke · Post by **kduke** » Tue May 26, 2009 2:32 pm

You have lost your mind.

qutesanju · Post by **qutesanju** » Thu May 28, 2009 7:49 am

Kim, could you please locate batch file........i am not aware @ TIPS page