[ES] Monitoring an ETL error table with Event Studio

[mikewalker]

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 Expand


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


Hope this might be useful to someone!

Regards
Michael

[COGNOiSe administrator]

Great tip! Thanks!