asked
How can I automate sql batch job to run script against a list of servers for my servers health check
Hello Everyone, I manage multiple sql servers in my company and I need to monitor the health of all the sql servers and also make sure the backups are running. Is there any way to automate a sql batch job that will run script against a list of servers at the same time for maintenance and health checking purposes? If this is possible, can anyone assist with the steps on how to create the batch job. Thanks and Warm Regards
I strongly recommend that you take a look into Policy Based Management and Central Management Server. These two tools can be combined to do health checks and compliance for your SQL Server instances. You can also just leverage CMS to run your queries against your SQL Farm via Powershell. Central Management Server will allow you to establish a connection utilizing windows authentication to groups of servers. Here are several links to videos like the one I did at PASS Summit in 2011 on this topic.
http://johnsterrett.com/presentations/evaluate-your-daily-checklist-against-100-instances-with-pbm-and-cms/ Here is a quick video going over running queries against your SQL Farm with CMS.
https://www.youtube.com/watch?v=WnyMwCFrdNw The following is an example of me using CMS with Powershell to capture backup data across my SQL farm.
http://johnsterrett.com/2011/05/12/passed-my-sqluniversity-powershell-midterm/ After you go through this material if you have questions feel free to ping me and I will be glad to spend a few minutes to help you out. You can reach me directly via
http://johnsterrett.com/about/contact-me/
No problem at all Abankwah. I look forward to hearing from you and sharing pointers I have learned about PBM and CMS throughout the years.
you might also have a look at
http://epmframework.codeplex.com/ which has a nice reporting part
I agree with Wilfred. All that information is included in the links above in my answer.
16 People are following this question.
