May 16, 2011 at 6:58 am
Hi all,
Anyone know if CMS can run scheduled SQL jobs against multiple servers?
Thanks
May 16, 2011 at 7:41 am
I can't find any evidence that it can.....other than the policy management stuff it almost seems like CMS is just a place to store server lists with the added advantage that you can execute AD-HOC queries against multiple servers.
BUT, you can do this anyway through registered servers......
:blink:
May 16, 2011 at 8:33 am
One option to consider, SQL Server Central Management System[/url] from CodePlex. But better still, read through this section in Books Online. It should get you where you need to go.
"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
May 17, 2011 at 1:39 am
Thank you, Multiserver Environment looks like exactly what I need. I think I was mis-sold CMS!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply