Can not generate reports using 7.5.2

etlbets · Post by **etlbets** » Fri Nov 30, 2007 1:17 pm

I am unable to generate reports using the command line.

C:\Progra~1\Ascential\DataStage7.5.2\DSDesign.exe /H=hostname /U=userid /P=passwd VZB xfmCOMDNonCoreToStgDsJob /R - Just returns

I have also done /RP c:\reports and it just returns as well.

It will not generate a report.

This appears to work in 7.5.1A. Is there something I need to do in order to get this to work.

When I drop the /R designer runs. When I add /R designer is not invoked and the command just returns.

Thanks

ray.wurlod · Post by **ray.wurlod** » Fri Nov 30, 2007 2:06 pm

Can you generate reports from within the Designer GUI?

etlbets · Post by **etlbets** » Fri Nov 30, 2007 2:11 pm

I can generate with in the Designer GUI. We have close to 6,000 jobs so need to find a way to automate the process.

Thanks

kduke · Post by **kduke** » Fri Nov 30, 2007 4:58 pm

This is straight out of the script on my tips page.

Code: Select all

%Designer% /H=%Host% /U=%User% /P=%Password% %Project% %%i /R /RP=%BackupDir%%DsxDate% /RX >> %LogFileName%

kduke · Post by **kduke** » Fri Nov 30, 2007 5:00 pm

The script DsJobReport.bat will do all jobs in a project but you can do it yourself if you want.

etlbets · Post by **etlbets** » Mon Dec 03, 2007 12:17 pm

Thanks Ken, I added the RX to the command and it worked.

Will be looking at DsJobReport.bat - I have a script that will do an export and then generate the report based what was exported.

Thanks again

kduke · Post by **kduke** » Mon Dec 03, 2007 7:40 pm

KIM!!!