Print Page - [ES] Monitoring an ETL error table with Event Studio

Title: [ES] Monitoring an ETL error table with Event Studio
Post by: mikewalker on 03 Sep 2007 08:56:40 AM

Hi

We've recently added an Event Studio agent to our list of error monitoring capabilities.

Our scheduled datawarehouse jobs write any ETL errors into an error table.

We've setup an Event Studio agent to monitor this table every 30 mins, and if any errors which have been entered in the last 30 mins are detected, a report is e-mailed to our ETL team.

The whole process runs seamlessly; and it's great to know that every 30 mins our "agent" is watching for errors, and will let us know when it finds any.

The event condition was as follows:

Code Select


([ErrorCode] = 'ERROR1234')   AND   (abs(datediff({mi}, getdate(), [ErrorDate] )) <= 30)

Hope this might be useful to someone!

Regards
Michael

Title: Re: [ES] Monitoring an ETL error table with Event Studio
Post by: COGNOiSe administrator on 03 Sep 2007 11:06:20 AM

Great tip! Thanks!

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Event Studio => Topic started by: mikewalker on 03 Sep 2007 08:56:40 AM