Generating Report automatically

horserider · Post by **horserider** » Thu Dec 11, 2008 7:07 am

I have almost 80 Datastage Jobs and 50 Datastag Master Sequence. I have to create the design document for each and every job and sequence.
Manually I can open each of these jobs/sequence and 'generate report' through designe but that would be time consuming.

Is there a way I can generate the design document automatically using some routine / Shell Script/ code ?

Appreciate any help.

chulett · Post by **chulett** » Thu Dec 11, 2008 8:35 am

Search the forums for dsdesign.exe which can be scripted to do what you need. Or grab an existing script from Kim Duke's website from his Tips & Tricks section.

kduke · Post by **kduke** » Thu Dec 11, 2008 6:44 pm

I think it is in DsReport.bat. I does a dsjob command to get a list of jobs then loops thru the jobs and calls dsdesign.exe for each job. I think the option is /RP for the html report of a job design. Pretty simple.