Trace all jobs with warning in Data Integration studio

[sanalitics]

Hi All,

Kindly let me know if there is a process or option or procedure to find all the jobs with warnings in DI environment.

Most of the time when the metadata of the table is updated without the impact knowledge, this would happen.

As an audit we would like to know if we could trace all such jobs with warnings.

thanks,

Sandeep

[AngusLooney]

Do you mean jobs that have executed and generated warnings, or jobs htat would produce a warming because the table(s) they use have been altered?

If the jobs are being executed, how? LSF, or by hand, or something else?

[sanalitics]

Hi Angus,

Thanks for the response!

The warning I mentioned is not after the execution of the job.

It is when ... say we delete 3 fields out of 10 from the metadata of the table "A" unknowingly, and impacts the job that has this table in it and has mapping of all the 10 fields of Table A.

Thanks,

Sandeep