 |
|
| Computers Forum Index » Computer - Databases - MS SQL Server » search for NULLS & notify... |
|
Page 1 of 1 |
|
| Author |
Message |
| Johnnyb... |
 Posted: Mon Oct 19, 2009 7:49 pm |
|
|
|
Guest
|
I have a database set up to receive rows from an application, then
another application comes along and picks up that data, leaving a
response in a column. Because both apps are proprietary and not very
friendly, I cannot get a lot of feedback from the apps themselves if
something goes wrong. Right now, I basically wait until someone
complains, then I go do a simple query to check for NULLS where the
2nd app should have responded while picking up the data. I want to be
more proactive and have SQL check for NULLS every 3 or 4 hours, then
send me an email or page when there are more than say, 100 NULLS in
the response column. I have looked and looked through the management
console (SQL 2005 btw), and I am not coming up with anything solid.
Does anyone have any ideas?
Thanks
John |
|
|
| Back to top |
|
|
|
| Greg D. Moore (Strider)... |
| Posted: Tue Oct 20, 2009 1:49 am |
|
|
|
Guest
|
"Johnnyb" <john.lutheran at (no spam) gmail.com> wrote in message
news:0fd63a62-4c0f-44b5-8c10-b69acbdf2ffd at (no spam) t11g2000prh.googlegroups.com...
Quote: I have a database set up to receive rows from an application, then
another application comes along and picks up that data, leaving a
response in a column. Because both apps are proprietary and not very
friendly, I cannot get a lot of feedback from the apps themselves if
something goes wrong. Right now, I basically wait until someone
complains, then I go do a simple query to check for NULLS where the
2nd app should have responded while picking up the data. I want to be
more proactive and have SQL check for NULLS every 3 or 4 hours, then
send me an email or page when there are more than say, 100 NULLS in
the response column. I have looked and looked through the management
console (SQL 2005 btw), and I am not coming up with anything solid.
Does anyone have any ideas?
Create a sproc that runs and returns the number of NULLS.
Then setup a scheduled task to run that every hour and if "rowcount" > 100,
emails you a "Hey, the sucky app is sending NULLS again!"
--
Greg Moore
Ask me about lily, an RPI based CMC. |
|
|
| Back to top |
|
|
|
|
|
All times are GMT
The time now is Fri Dec 04, 2009 7:43 pm
|
|