We have a table in a database on SQL Server 2005. This table continuously has records added to it and an SQL Agent job processes it every few minutes and processes and then empties the collected records. Rarely, there are errors in some of the records that prevents them being processed properly. When this happens, manual intervention is required to see what is wrong and force processing of the records. But, I need to know that there is a problem with some records before I can investigate.
So, what I am looking for is a way to run a report on this table and email it to myself IF there are any records stuck in there. I am hoping that there is a simple way to do this without resorting to programming some application. We have integration server and reporting server installed on the same server as the database engine but I have no idea how to use either.