SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Want to auotomate the job using server group


Want to auotomate the job using server group

Author
Message
Jitendra Padhiyar
Jitendra Padhiyar
Mr or Mrs. 500
Mr or Mrs. 500 (512 reputation)Mr or Mrs. 500 (512 reputation)Mr or Mrs. 500 (512 reputation)Mr or Mrs. 500 (512 reputation)Mr or Mrs. 500 (512 reputation)Mr or Mrs. 500 (512 reputation)Mr or Mrs. 500 (512 reputation)Mr or Mrs. 500 (512 reputation)

Group: General Forum Members
Points: 512 Visits: 674
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.
Attachments
ServerGroup.jpg (12 views, 36.00 KB)
Jitendra Padhiyar
Jitendra Padhiyar
Mr or Mrs. 500
Mr or Mrs. 500 (512 reputation)Mr or Mrs. 500 (512 reputation)Mr or Mrs. 500 (512 reputation)Mr or Mrs. 500 (512 reputation)Mr or Mrs. 500 (512 reputation)Mr or Mrs. 500 (512 reputation)Mr or Mrs. 500 (512 reputation)Mr or Mrs. 500 (512 reputation)

Group: General Forum Members
Points: 512 Visits: 674
Hello Gila Monster,

Can you please help me ?

I did not recieve any reply from other masters. ;-)
Derek-2008
Derek-2008
Grasshopper
Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)

Group: General Forum Members
Points: 12 Visits: 110
You could use linked servers and then make a script with the fully qualified name
Leonard Rutkowski
Leonard Rutkowski
SSC Veteran
SSC Veteran (278 reputation)SSC Veteran (278 reputation)SSC Veteran (278 reputation)SSC Veteran (278 reputation)SSC Veteran (278 reputation)SSC Veteran (278 reputation)SSC Veteran (278 reputation)SSC Veteran (278 reputation)

Group: General Forum Members
Points: 278 Visits: 1213
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
Jitendra Padhiyar
Jitendra Padhiyar
Mr or Mrs. 500
Mr or Mrs. 500 (512 reputation)Mr or Mrs. 500 (512 reputation)Mr or Mrs. 500 (512 reputation)Mr or Mrs. 500 (512 reputation)Mr or Mrs. 500 (512 reputation)Mr or Mrs. 500 (512 reputation)Mr or Mrs. 500 (512 reputation)Mr or Mrs. 500 (512 reputation)

Group: General Forum Members
Points: 512 Visits: 674
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 ?
Leonard Rutkowski
Leonard Rutkowski
SSC Veteran
SSC Veteran (278 reputation)SSC Veteran (278 reputation)SSC Veteran (278 reputation)SSC Veteran (278 reputation)SSC Veteran (278 reputation)SSC Veteran (278 reputation)SSC Veteran (278 reputation)SSC Veteran (278 reputation)

Group: General Forum Members
Points: 278 Visits: 1213
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
Jitendra Padhiyar
Jitendra Padhiyar
Mr or Mrs. 500
Mr or Mrs. 500 (512 reputation)Mr or Mrs. 500 (512 reputation)Mr or Mrs. 500 (512 reputation)Mr or Mrs. 500 (512 reputation)Mr or Mrs. 500 (512 reputation)Mr or Mrs. 500 (512 reputation)Mr or Mrs. 500 (512 reputation)Mr or Mrs. 500 (512 reputation)

Group: General Forum Members
Points: 512 Visits: 674
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 ?
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search