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 |
|
dewacorp.alliances
452 Posts |
 Posted - 2006-09-04 : 21:14:35
|
| Hi allAt the moment, we're managing multiple SQL Server environments (cluster, single box, single box with standby server) and multiple databases. At the moment, the way to check the system is going to each of the server and looking the jobs that is running. I am thinking to make more efficient. Is there any perhaps a software that we can download (free or comercial) or perhaps a central script that can look at interogate each server.Any feedback or comments ... I am really appreciated.Thanks |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-09-04 : 23:16:45
|
| create a job that will send an email on the status of the jobs, run this at the beginning of your daydon't believe in spending if the requirement is simple enough to accomplish, most systems would employ the same method anyways if not similar (connect to the server, collect information, run this in a job that gathers info at n-intervals)--------------------keeping it simple... |
 |
|
|
dewacorp.alliances
452 Posts |
Posted - 2006-09-05 : 00:15:57
|
| Notifying email is exactly what we do but I found that you are relying on email which is alright but it will be nice if there is a graphical interface for it using WMI or something. |
|
|
|
|
|
|
Managing Multiple SQL Servers and Databases