Page 1 of 1
Generate Job Statistics as html report
Posted: Mon Dec 08, 2008 6:07 pm
by Lotus26
Hi
Can we generate Statistics of a job as html document . I want to automize that part .So I created a batch file and I tried windows command of
dsjob.exe as
dsjob.exe /H=%Host% /U=%User% /P=%Password% ProjectName JobName > LogFile
But I think I am missing something and hence I am not able to generate the report . Can anybody help me out in this and tell me what options I can use .
I would appreciate your time.
Posted: Mon Dec 08, 2008 6:35 pm
by chulett
You should be using dsdesign.exe not dsjob.exe and you need to double-check that you are passing it enough parameters. Search the forums here for "dsdesign" to see examples of how it is called.
Posted: Mon Dec 08, 2008 10:12 pm
by kduke
Try this:
Code: Select all
%DsDesignerCmd% /H=%Host% /U=%User% /P=%Password% %Project% %%i /R /RP=%BackupDir%%DsxDate% /RX >> %LogFileName%
Re: Generate Job Statistics as html report
Posted: Thu Apr 02, 2009 2:00 am
by qutesanju
hello Lotus26 can u pls share the automated batch file here,
I also want to automate this task.I need to generate HTML report for all the job from my project .
I can do this for singel job as
1 open the job
2 then File-->generate HTML report
but as there are plenty of jobs in one project so how can I do this for plenty of jobs?
Lotus26 wrote:Hi
Can we generate Statistics of a job as html document . I want to automize that part .So I created a batch file and I tried windows command of
dsjob.exe as
dsjob.exe /H=%Host% /U=%User% /P=%Password% ProjectName JobName > LogFile
But I think I am missing something and hence I am not able to generate the report . Can anybody help me out in this and tell me what options I can use .
I would appreciate your time.
Posted: Thu Apr 02, 2009 5:31 am
by ray.wurlod
The second person personal pronoun in English is spelled "you", not "u".
Please strive for a professional standard of English on DSXchange, because even good English is difficult enough for non-native speakers, and also because DSXchange is not an SMS-enabled device.
Posted: Thu Apr 02, 2009 9:08 am
by kduke
This does not do job statistics. This report shows job design. If you want row counts and similar statistics then you need to state exactly what you are looking for.
Posted: Thu Apr 02, 2009 2:16 pm
by chulett
Regardless, build a looping structure. Use 'dsjob' to get a list of the jobs in the project and then iterate through that list and get whatever it is you need from each one in that fashion.