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 |
|
sqlchiq
Posting Yak Master
133 Posts |
 Posted - 2008-09-12 : 10:22:14
|
| Is there a way to create some kind of alert system so that you get some kind of email when shit isn't working.For example I just found out one of the tables we have hasn't been updated in 2 months, and now we need it. For that example we would need something that if say there's no data update in over a week, have it email me.Or for another example if a table isn't picking up all the data, have it so that if the latest update contains fewer than x amount of entries email me.I need a way to create alerts similar to these in nature, is it possible on SQL server? |
|
|
bjoerns
Posting Yak Master
154 Posts |
Posted - 2008-09-12 : 10:27:35
|
| Of course. Use SQL Server Agent Jobs. |
 |
|
|
|
|
|
Alerts for when shit hits the fan?