Page 1 of 1

Datastage job auditing

Posted: Wed Feb 27, 2008 11:17 am
by mydsworld
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

Posted: Wed Feb 27, 2008 4:55 pm
by ray.wurlod
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

Posted: Wed Feb 27, 2008 11:19 pm
by kduke
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.

Posted: Wed Feb 27, 2008 11:20 pm
by kduke
Ray is correct though EtlStats will get you close. At least get the data into tables.

Posted: Wed Feb 27, 2008 11:43 pm
by ray.wurlod
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.