Post reply

Central management Server

  • December 21, 2012 at 11:12 am

    #272348

    I have 70 production server and I made my desktop as a Central Management server

    I have configure all the servers on my desktop via central management server and want to run a daily automated report for any blocking happening in last 24 hours, how do I automate this query through SQL Agent job or is any other way I can automate this?

    My central management register file is at C:\anyBlocking.regsrvr

  • December 21, 2012 at 11:21 am

    #1571019

    My understanding is the CMS allows for the logical grouping of your registered servers that can be shared in your organization.

    It also allows you to run queries against all servers in said group. This has to be done manually. You can not do things like create a job to run a script against all servers or have a proc do the same.

    What your asking for would probably be better suited for PowerShell or some third party tool.

    ** I know it sounds counter-intuitive to not have the ability to automate these types of things in CMS, but I'm pretty darned sure it's just the way it is. **

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg

  • December 21, 2012 at 11:25 am

    #1571020

    thanks, is anyway through trigger, is it possible?

  • December 21, 2012 at 11:40 am

    #1571022

    you could use osql utility and run the script under a sql agent job and send the results to a txt file using dbmail.

    Also, Check this customized powershell script to run a SQL query on multiple servers and save results to excel here[/url]

    [font="Tahoma"]
    --SQLFRNDZ[/url]
    [/font]

  • December 21, 2012 at 11:59 am

    #1571026

    Since I have 2 tab on central Management Server (Prod 30,Prod 40) which are on same file c:\anyblocking.regsrvr.

    How should I pass the paramter and use OSQL?

  • December 21, 2012 at 3:46 pm

    #1571094

    osql.exe is not a good tool to use for new development. It has been deprecated since SQL 2005 was released. If you need a command line query tool use sqlcmd.exe.

    That said, PowerShell may be a better vehicle still for iterating over servers in a CMS group.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply