Monitoring SQL 2005 Table using SCOM 2007

Kalpesh — Mon, 19 May 2008 21:58:52 GMT

Hey

I am new to SCOM 2007 and was looking at ways to monitor SQL Server table based on value that is populated by other application. To explain the scenario that I want to monitor is that there is a table in database that has errors logged with date time stamp column in that table. Now I want to check that date time stamp to see the frequency of new errors and severity of that error. Based on that I would like SCOM to say if the error was critical or warning.

I already have a script in SQL that does that and returns a status code, but I want to use SCOM to monitor that status code and alert.

Is there a way to do this?

Thanks in advance.

Search results matching tags 'rules' and 'SCOM 2007 Script'

Monitoring SQL 2005 Table using SCOM 2007