search for a value passed to parameter in whole repository

nsm · Post by **nsm** » Wed Oct 19, 2011 7:02 pm

Hi,

a table in our database is loaded by multiple jobs and are unknown to us as we just acquired the system.

I need to search for a particlar value passed for this parameter and find out the culprit jobs.

Can you please let me know if there is a way to do it?

Thanks
nsm.

ray.wurlod · Post by **ray.wurlod** » Wed Oct 19, 2011 7:14 pm

Probably search through an export file of the project for the parameter name.

eostic · Post by **eostic** » Wed Oct 19, 2011 9:16 pm

Are you looking for the "value" that might have been passed to a parameter, without knowing the parameter or the job name? A Metadata Workbench query can do that, "if" you were collecting Operational Metadata for the particular Jobs in question....

Ernie

emblem_user · Post by **emblem_user** » Mon Nov 07, 2011 9:33 am

Hi,

I know the parameter and I have the value that's been passed to it but I don't know the job where its been passed.

I need to find out the job where that value is been passed.

Thanks
nsm.