generating jobs reports
Moderators: chulett, rschirm, roy
generating jobs reports
Hello!
It is known that it is possible to generate job report (in Designer) in HTML or XML!
But is it possible to generate such reports for many jobs in one time (without need to open each job in designer and generate report)??
Regards
It is known that it is possible to generate job report (in Designer) in HTML or XML!
But is it possible to generate such reports for many jobs in one time (without need to open each job in designer and generate report)??
Regards
LUK
You are able to generate reports using the command line.
You could write a job that gets the job list, then looping thru that, run the create report command for each job.
Regards,
You could write a job that gets the job list, then looping thru that, run the create report command for each job.
Code: Select all
dsdesign.exe /H=hostname /U=username /P=password /O=omitflag project
job_name | /SC shared_container_name /R /RP=report_pathname /RT=stylesheet_pathname /RX
Precious
Mosher's Law of Software Engineering: Don't worry if it doesn't work right. If everything did, you'd be out of a job.
Mosher's Law of Software Engineering: Don't worry if it doesn't work right. If everything did, you'd be out of a job.
I posted a batch file that will do a job report for every job on ADN. I prefer JobReport written by Tony Curcio. I think it creates a nicer document. So created a wrapper for his routine which will do all jobs and all routines. I wrote the routine part to look the same as his html. It creates and index to all the other pages as well. You can download it from ADN and my tips page. It is called GenHtml.
DwNav also generates all of this plus a where used link by table and hash file name which I call job metadata. You can download it from my web site and request a 30 day evaluation copy for free.
DwNav also generates all of this plus a where used link by table and hash file name which I call job metadata. You can download it from my web site and request a 30 day evaluation copy for free.
Mamu Kim
I've found and download it from your web page, but I can't import *.dsx file.I posted a batch file that will do a job report for every job on ADN. I prefer JobReport written by Tony Curcio. I think it creates a nicer document. So created a wrapper for his routine which will do all jobs and all routines. I wrote the routine part to look the same as his html. It creates and index to all the other pages as well. You can download it from ADN and my tips page. It is called GenHtml.
I have message that I it is possible only if my DS client code page will be 1252 (my current code page is 1250)!
LUK
Luk, edit the code setting right at the beginning of the .DSX file and you will be able to import it.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
OK! I can do it, but how can I generate report from job which exist on server (UNIX) and I have my client on another machine (Windows)??You are able to generate reports using the command line.
You could write a job that gets the job list, then looping thru that, run the create report command for each job.
I have no client installed on UNIX!!
LUK
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
With DataStage 7.5.1 the command line job report with the /R report switch turned on provides a bitmap and a HTML document with links between the bitmaps and the attributes section of the HTML document via some clever rectangle reference coordinates properties on the bitmap image.
<img src="imagename<map name="jobmap"><area shap="rect" cords="..."href=...>
<area shape="rect" coords="..." href = ...>
<area shape="rect" coords="..." href = ...>
<area shape="rect" coords="..." href = ...>
In other words when you click on the picture of a job stage it takes you to the job stage properties in the report.
<img src="imagename<map name="jobmap"><area shap="rect" cords="..."href=...>
<area shape="rect" coords="..." href = ...>
<area shape="rect" coords="..." href = ...>
<area shape="rect" coords="..." href = ...>
In other words when you click on the picture of a job stage it takes you to the job stage properties in the report.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: generating jobs reports
>>It is known that it is possible to generate job report (in Designer) in HTML or XML!
Is this possible in 7.1 too? If yes, how? I know there is an option available in 7.5
-Nagesh.
Is this possible in 7.1 too? If yes, how? I know there is an option available in 7.5
-Nagesh.