[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Multiple SQL  services stop through Orchesrator

Posted on 2014-01-02
6
Medium Priority
?
291 Views
Last Modified: 2014-01-14
Hi,

 I am looking to orchestrate the multiple services start / stop through orchestrator. Please suggest.

Thanks,
Prasad,
0
Comment
Question by:Prasadkosana
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 8

Expert Comment

by:Leon Taljaard
ID: 39762795
Hi

This is definitely possible and really easy, let me know what exactly you require and I will be more than happy to help.

Do you have a list of servers ?

Have a look at a few of my Orchestrator Articles as well to give you more ideas.

Thanks
0
 

Author Comment

by:Prasadkosana
ID: 39768147
Hi Leon,

  Its a SQL server having a list of Instances and SQL services. I need to restart them one after other in single step. Any suggestions!!

Thanks,
Prasad
0
 
LVL 8

Expert Comment

by:Leon Taljaard
ID: 39770281
Hi Prasad

Sure, is it just a single server with multiple windows services that you would like to restart, do you also need to restart them at a certain time of day or week ?

You can do a really simple runbook like the following :

Restart Services RunbookThe above is a really simple runbook that you can have running and set a time or date that it needs to repeat, you can also add a schedule which it would check as well.

Monitor Date/TimeHere you can set the schedule that it will actually fire off

Restart ServiceAnd then this should be the same for all the others with the exception of the service name.

Like I said this is really simple, you could also add conditions on the links to only continue to the next restart service if the previous one was a success, you could also add a "check service status" or even mail you if one of the restarts fail, log an event and create a SCOM alert.

Possibilities are endless :)

Hope this helps

Leon
0
Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

 

Author Comment

by:Prasadkosana
ID: 39771029
Is there a way in figure 1 .. Instead of 3 services are designed cant it be one and restart 3 services may be lopping or any other... If we have 6 services ..We need to create 3 stop / start services..

  I need a single stop /start object and it will be restarting many depending on the input provided

Thanks,
Prasad
0
 
LVL 8

Accepted Solution

by:
Leon Taljaard earned 2000 total points
ID: 39775844
Hi

Yes sure you can, you could list the service names in a text file and then use the read line activity and have that pass the service name one at a time to the restart service activity therefore having 2 activities only which one of them would be the restart service.

Look at the attached files

Goodluck

Thanks
Read-Line1.PNG
Read-Line2.PNG
Read-Line3.PNG
Read-Line4.PNG
0
 

Author Closing Comment

by:Prasadkosana
ID: 39778580
Thanks Leon... It really helps
0

Featured Post

Survive A High-Traffic Event with Percona

Your application or website rely on your database to deliver information about products and services to your customers. You can’t afford to have your database lose performance, lose availability or become unresponsive – even for just a few minutes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have been working with Orchestrator 2012 for a few months now and I must say it has surprised me at every turn, with its functionality and integration capabilities it has really shown me how the System Center Suite of products really all fit toget…
Many companies are making the switch from Microsoft to Google Apps (https://www.google.com/work/apps/business/). Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
Viewers will learn the different options available in the Backstage view in Excel 2013.
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

649 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question