We help IT Professionals succeed at work.

Multiple SQL  services stop through Orchesrator

396 Views
Last Modified: 2014-01-14
Hi,

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

Thanks,
Prasad,
Comment
Watch Question

Leon TaljaardSystem Center Specialist - Architecture
CERTIFIED EXPERT

Commented:
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

Author

Commented:
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
Leon TaljaardSystem Center Specialist - Architecture
CERTIFIED EXPERT

Commented:
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

Author

Commented:
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
System Center Specialist - Architecture
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
Thanks Leon... It really helps

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.