topic Trace all jobs with warning in Data Integration studio in SAS Data Management

Trace all jobs with warning in Data Integration studio

sanalitics — Thu, 22 Nov 2018 06:31:32 GMT

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

Re: Trace all jobs with warning in Data Integration studio

AngusLooney — Fri, 23 Nov 2018 08:22:54 GMT

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?

Re: Trace all jobs with warning in Data Integration studio

sanalitics — Fri, 23 Nov 2018 10:56:16 GMT

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