Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Want to auotomate the job using server group Expand / Collapse
Author
Message
Posted Friday, October 18, 2013 4:01 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 8:53 AM
Points: 209, Visits: 573
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.


  Post Attachments 
ServerGroup.jpg (10 views, 36.23 KB)
Post #1506056
Posted Monday, October 21, 2013 12:25 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 8:53 AM
Points: 209, Visits: 573
Hello Gila Monster,

Can you please help me ?

I did not recieve any reply from other masters.
Post #1506549
Posted Monday, October 21, 2013 12:26 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, October 30, 2014 7:19 AM
Points: 12, Visits: 104
You could use linked servers and then make a script with the fully qualified name
Post #1506789
Posted Tuesday, October 22, 2013 9:28 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, November 4, 2014 8:24 AM
Points: 160, Visits: 979
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

Post #1507220
Posted Thursday, October 24, 2013 3:42 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 8:53 AM
Points: 209, Visits: 573
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 ?
Post #1507942
Posted Thursday, October 24, 2013 6:32 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, November 4, 2014 8:24 AM
Points: 160, Visits: 979
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
Post #1508008
Posted Monday, October 28, 2013 6:18 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 8:53 AM
Points: 209, Visits: 573
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 ?
Post #1508833
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse