DSXchange

I would like to do the same for jobs built. If we could gather the number of jobs, links and columns created each month then the difference is how many new items created. Maybe we cannot easily get the number of items changed. If we could then we could post the most number if jobs per developer, the...

I was wondering if I created some jobs to gather job run time statistics would you run them on your site and share them. If we knew your hardware like Sun 480 and then rows per second for all jobs by stage type, megabytes per second fpr same. Lets say your rows per second were averaging 500 and ever...

The BASIC code is

http://www.dsxchange.com/viewtopic.php? ... ight=RESET

The shell script is

http://www.dsxchange.com/viewtopic.php? ... ght=RunJob

Craig, another great point. This split into so many different directions but all very related to comlexity and the measure of work done.

Next time anyone asks you do describe the complexity of your work then print this topic. It should help.

Well said.

If these guys were paid by the hour then yes I would try to figure out who did the most work. As a business man then I am required to find good talent and make sure they are productive. You also want to make sure that what they create is good quality and easily to modify. Those that think it is art ...

Control-m wouild make this a lot easier.

Sorry, it has been out there for several days now. I just patched the missing routines. Craig this should compile now. I am doing a rewrite of the table structures. It may take a while before I can finish it. It should be a star schema with a fact table when I am done. I have a couple of fact tables...

I would reuse the instance ids every other hour or every 3 hours then you do not have a lot of instances ids.

What is the problem? Is there too many jobs and it is hard to figure out the order? Is something not running? What is the issue otherwise kick it off ansd see what breaks.

Good. I think everybody got my point that more complex is not neccesarily better or more intelligent but there is something to be said for measuring work done by counting objects or tasks done. If you use a weighted average like jobs take more time to create than links and more time than columns bec...

Do a search. I posted code to do this in BASIC and in a shell script. If you cannot find it then let us know.

If it was me then I would build it in BASIC and view it on a web page. We could easily change DsWebMon to do this. It is a very good idea for people who do not know DataStage. Maybe show me all jobs finished in the last hour. EtlStats could be modified to do this from Oracle. The across project part...

JobReport works in 7.1. You can download it and GenHtml from ADN or my tips page. I think 7.5.1 was the first version to document a job from Designer or dsjob.