Getting Job Information

pradkumar · Post by **pradkumar** » Thu Sep 06, 2007 3:24 pm

Hi

I need to get the job information from Data Stage. My idea is to get the
Job Name,Source, Source Table(s) Name,Target, Target Table name.

Is there any job utility with which we can get this?

Could anyone share their ideas on this

Regards

ray.wurlod · Post by **ray.wurlod** » Thu Sep 06, 2007 3:48 pm

Download EtlStats from Kim Duke's web site.

kduke · Post by **kduke** » Thu Sep 06, 2007 7:08 pm

You need DwNav. Some of this is in EtlStats but it is too hard to exaplin. DwNav uses Reporting Assistant for Server jobs. It can easily report on these relationship. You could do it yourself using Access and Reporting Assistant tables.

4friends · Post by **4friends** » Thu Sep 06, 2007 10:25 pm

ray.wurlod wrote:Download EtlStats from Kim Duke's web site. ...

go to command prompt and type LIST DS_AUDIT (OR) DS_JOBS

ray.wurlod · Post by **ray.wurlod** » Thu Sep 06, 2007 10:36 pm

Please elaborate on how this will yield source, source table, target and target table.

4friends wrote:go to command prompt and type LIST DS_AUDIT (OR) DS_JOBS

DSXchange

Getting Job Information

Getting Job Information

to know about the job information