June 16, 2010 at 12:04 am
I have a stored proc which returns job information like Jobname, whenit ranlasttime,runstattus etc...
No issues with proc...
but i have 15 prod servers (to be monitored )on which i require these jobs information from a central location. what i mean is i should be able to see the information of all the jobs on 15 servers from a single location. Link server is not allowed due to security reasons...
I appreciate if given any approach / direction in accomplishing this task..
TIA...
June 16, 2010 at 6:09 am
How can u connect server with out link server??:cool:
As you told you want to retrieve information from a centralize server, then centralize server should be connect to each and every prod server.
June 16, 2010 at 6:24 am
I would look at getting a license for SQL Server 2008 R2. You can then use multi-server management to put this to work. Otherwise, you need to cobble something together using interlocking linked servers or something. If you're going to go to that much trouble to build a monitoring system from scratch, then I'd suggest just using another language to build out the mechanism for gathering the data from the various servers. Powershell scripts would work well for this.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 17, 2010 at 1:01 am
Thanks Grant..Powershell scripts seems to be better option...
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply