Monitoring SQL 2005 Table using SCOM 2007

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.

Where do you return your error code, to an Event log or a log file? SCOM can monitor these things, it can run the script for you and alert based on the return code as well.

Right now the errors are logged in SQL table. I would like to monitor that using SQL query. We are not writing to any event log or log file at the moment. I would like to know how to monitor a SQL table. Currently I have some old application using SQL query to monitor that table. but I would like to move that to SCOM so would like to know how I can monitor a SQL table.

 Thanks in advance.

 I've been working on the same sort of thing to monitor an application that logs job status to a table.  I used the script linked below as the starting point, scheduled the script to run and setup an alert for error events.

http://www.systemcenterforum.org/wp-content/uploads/sqlperfcheck2.txt