DSXchange

I think it is in DsReport.bat. I does a dsjob command to get a list of jobs then loops thru the jobs and calls dsdesign.exe for each job. I think the option is /RP for the html report of a job design. Pretty simple.

dsjob -report XML

is what you need. You need to give it project and job name. XML is optional.

There are lots of jobs in EtlStats which do this.

Mr. Pick is complaining about Pick style. OMG!

Try this:

The key is 2 part on jobs. The second part is the job name. You would need to write an I-descriptor to create a job name field to join to DS_JOBS and then maybe to DS_JOBOBJECTS to get short description or long description. If you want to read this in DataStage then you need a few more tricks.

We do this all the time and it works fine. On Insert we leave off the column so the database will assign the value.

When you run DSJobReportDbDriver use ALL for JobName and it will get row counts on all jobs. You can also use a sequence name or a folder name. So if all your jobs are in one folder then it will get all row counts for all jobs in that folder.

You could remote execute dsjob.

There is a command called Dwn_ExecTCL.exe which can run this SQL statement from the client. So you could automate this whole process. This command is in Scripts.zip on my tips page. Do a search this has been covered in other posts.

There is a batch file which generate reports all the jobs in a project on my tips page. Save you some time by downloading it.

That is why with EtlStats I run without waiting. So the next sequence kicks off while EtlStats us running the background. That is also why I do not like after job routines which gather this information. It adds a couple minutes to each job ran. Not good. Your overall run times will increase when you...

Download EtlStats from my Tips page. Do a search. Lots of posts about it.

You need to set your ulimit to unlimited.

Yes. If a query is based on one table then it is updatable.