patternsqlMinor
Running queries against multiple servers
Viewed 0 times
serversagainstrunningmultiplequeries
Problem
I want to use a Central Management Server, with a server group underneith, to run management queries against multiple server.
I know how to run a query against the whole group through SSMS, but I want to schedule queries to run through server agent.
How do I do this?
I know how to run a query against the whole group through SSMS, but I want to schedule queries to run through server agent.
How do I do this?
Solution
What you're looking for it sounds like is the Target Servers of a job. You can add your servers to this portion so that the job is run against your desired servers.
BOL documentation on Target Servers: http://msdn.microsoft.com/en-us/library/ms189553.aspx
BOL documentation on Target Servers: http://msdn.microsoft.com/en-us/library/ms189553.aspx
Context
StackExchange Database Administrators Q#29222, answer score: 4
Revisions (0)
No revisions yet.