August 17, 2006 at 4:04 pm
DBA. I am looking for in particular as mentioned below.
a> If Server is rebooted & due to any reason if SQL Server Services
didn't came up or not started, then SQL DBA should receive PAGE/EMAIL
about this problem/error
b> Due to any reason SQL Server Services were stopped or stopped
working, SQL DBA should get notify thru PAGE/EMAIL.
Currently we don't want to go for any 3rd party tool. I am looking for
something that can answer my above to requirements. Any help will be
appreciated & thanking you in advance.
August 21, 2006 at 8:40 am
We currently use NetIQ to monitor all these occurences. It will look at the application and system logs and send an email to whoever needs to be notified. You tell it what events you want to monitor. It works great. We also use it to notify us if the drive space is low or if certain jobs failed. If you set up your notification on jobs to write to the app log it makes it easy.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply