Datastage job auditing

mydsworld · Post by **mydsworld** » Wed Feb 27, 2008 11:17 am

Hi,
I am trying to build up a job that will generate auditing information (like start date,rowcount etc) of other jobs (using jobname as parameter).Whats the best way to do that in DS8.
Thanks

ray.wurlod · Post by **ray.wurlod** » Wed Feb 27, 2008 4:55 pm

Any way that works. I would do it in a job control routine, because that's what I'm familiar and comfortable with. But it could be done completely graphically - though you would need a job sequence.

You could also investigate EtlStats from Kim Duke's website

kduke · Post by **kduke** » Wed Feb 27, 2008 11:19 pm

We are working on that now. We would like Gantt chart for job run times so we could easily see overlapping jobs. Preston sort of got it started. Not sure if I can finish it. The worse part is they would not print.

kduke · Post by **kduke** » Wed Feb 27, 2008 11:20 pm

Ray is correct though EtlStats will get you close. At least get the data into tables.

ray.wurlod · Post by **ray.wurlod** » Wed Feb 27, 2008 11:43 pm

I notice that you are using version 8.x.

You can also use the Resource Estimation tool, based on a 100% sample, which will give you immense amounts of detail.