Reporting feature - creating a job info report

jfarber1 · Post by **jfarber1** » Tue Jan 15, 2013 8:12 am

I'm trying to create a report within the DS Reporting Console. I want to make a report that will show all the DS job information to see if i can collect all the comments describing the jobs. The problem is that i can't complete the report because it will not allow me to select a project/job. Do you know why that is?

ray.wurlod · Post by **ray.wurlod** » Tue Jan 15, 2013 3:38 pm

Welcome aboard.

Have you tried creating the report within DataStage Designer? Those reports do include comments, and are subsequently accessible within the Reporting Console.

I do not know why you can't select jobs within the Reporting Console - can you take us through the exact steps you are using?

vmcburney · Post by **vmcburney** » Tue Jan 15, 2013 6:23 pm

The DataStage Reporting Console is one of the worst things ever invented. The DataStage Designer Generate Report function is much better, it will give you a HTML report with an image of the job showing the annotation stages and HTML properties of each stage showing stage comments. Kim Duke once wrote a procedure to cycle through and generate HTML documentation for every job in a project - is there anything that does this in version 8.7 or 9.1?

kduke · Post by **kduke** » Sun Jan 20, 2013 11:24 am

Not sure it still works in version 8. Definitely worked in 7. I think all you have to do is add domain to command line. It is in Scripts.zip. I think it is called DsJobReport.bat.