Datasource Connection jobs

alexcol · Post by **alexcol** » Tue Jul 26, 2011 2:16 pm

Good morning, in a Production System There are hundred of jobs extracting data from heterogenius and operational source RDBS like Oracle, SqlServer

In Designer i click on each parallel job and it shows me by means of environment variabales the Database source connection.

But the problem is that in a bunch of jobs extracting info from different database sources it takes me too much time to get that info for all jobs.

So the question is: Is there any command or like a select statement or code that allows me to see which jobs are accessing a specific database source into the ETL context.?

As i newbie or dummy i am in teradata issues,could you give a shed light for any tool or something that helps me out find what i am looking for?

TThanks for your help

kduke · Post by **kduke** » Tue Jul 26, 2011 7:40 pm

I always did this after the fact with EtlStats. You can tell by the ETL_PARAM_HIST table. Sort by PARAM_VALUE on the parameter name in question.