Want to auotomate the job using server group

  • Hello Masters,

    I have some same scripts that I have to run on bunch of server. To save time I creaed local server group and have added all the servers and now I can run that script and its giving result of all the servers.

    My question is "Is it possible to automate that script each day using local server group?" OR using "Central management Servers?" I am using this technicque for first time kindly advice me and guide me. Attached is the screen shot for understanding.

  • Hello Gila Monster,

    Can you please help me ?

    I did not recieve any reply from other masters. 😉

  • You could use linked servers and then make a script with the fully qualified name

  • I've never been able to schedule a job, to use the registered servers, although if i remember correctly, there is a way to retreive the list, if they are in the Central Management Servers list. If I need to schedule a job, and get the output, I use Powershell, especially if I need to connect to multiple servers. I'm not a big fan of linked servers, for a variety of reasons.

    Leonard

  • Thanks a lot Derek and Leonard,

    Can you please gimme some URL to get step by step guide for linked server ? Or any URL to get aware of central server management ?

  • Here is a link to an MSSQL tip: http://www.mssqltips.com/sqlservertip/2397/sql-server-central-management-servers-system-tables/. That is an article that explains how to get the Central managmeent server list.

    To access using a linked server, you can use Openquery (You can google that), or just a select * from linkservername.databasename.schemaname.tablename.

    And, the last couple of days, I have been recommending Powershell, on a couple of these forums, to do exactly what you need to do. Very easy to set up and run as a scheduled job, and you can access multiple servers. I have used it for 4 or 5 years now, and it works great.

    Leonard

  • Hello Leonard,

    I used Central mangement Server and have added 20 SQL servers of the same domain in the group, some of them are of sql server 2005 and around 3 servers are of sql server 2000. When I am trying to evaluate policy to check failed backup, the policy check failed for the lower versin (2005 and 2000).

    Is PBM(Policy based mangement) is not working on SQL Server 2005 ?

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

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