Page 1 of 1

Generating Report automatically

Posted: Thu Dec 11, 2008 7:07 am
by horserider
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.

Posted: Thu Dec 11, 2008 8:35 am
by chulett
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.

Posted: Thu Dec 11, 2008 6:44 pm
by kduke
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.