June 4, 2013 at 12:12 am
i would like to configure alerts in all the sql servers to the below
1. disk space on the server
2. log space used of all the databases
3. alert when the job is failed
4. server shut down \up.
replies are appreciated .
June 4, 2013 at 4:28 am
Make sure you have "database mail" set up correctly. Most solutions rely on this feature.
In the scripts section of SQLServerCentral many solutions can be found. Just look around whats available.
You can add an alert to each job (under "notifications") and specify when this must be sent.
You can't send an alert when a server shuts down. Because of this shutting down all activities will be stopped. When you want to monitor a server shutdown (unavailable) you'll need to monitor this from a centralized server.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply