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 |
|
Gopher
Yak Posting Veteran
83 Posts |
 Posted - 2007-07-04 : 09:10:10
|
| Hi AllI have a problem which I am attempting to find a solution for. Basically my situation is this:We currently have 26 SQL Servers, some 2000 and some 2005. There are various jobs and backups running on all of these servers and as you can imagine monitoring all of these is a nightmare!What I want to do is create a website or report which can tell me the status of the jobs and backups. So that I can check one website or report to find the status and if necessary then I can navigate to that server!Does anyone else have this problem and if you have found a solution!Thanks in advanceGopher |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-04 : 17:32:57
|
| Or you can use MSX in sql agent so only need to monitor couple of master servers for job status. |
 |
|
|
Gopher
Yak Posting Veteran
83 Posts |
Posted - 2007-07-05 : 04:57:05
|
| oh thanks, do you have anymore information on how to do this? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-05 : 12:23:43
|
| You can get details in books online. |
|
|
|
|
|
|
Monitoring Backups, Jobs etc.