Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
 Posted - 2008-03-30 : 01:32:24
|
| is there a way to set up a scheduled sp to email me if no records are added to a certain table within the hour?is this possible? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-03-30 : 01:38:49
|
| Sure. You could keep track of the row count in a separate table if no deletes happen on it or check the latest datetime column if getdate() is used for inserts. We use the second option here to ensure our backend processes are pumping data in still.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
sp to email me if no records added