generate HTML report in datastage
Moderators: chulett, rschirm, roy
generate HTML report in datastage
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?
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?
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.
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
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...
Pneuma Lin.
pneumalin@yahoo.com
pneumalin@yahoo.com
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
viewtopic.php?t=124036
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Thanks for the sharing, and it did work. I also found the syntax in Page 227 Designer Guide.
Pneuma Lin.
pneumalin@yahoo.com
pneumalin@yahoo.com
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
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