Link to home
Create AccountLog in
Avatar of Prasadkosana
Prasadkosana

asked on

Multiple SQL services stop through Orchesrator

Hi,

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

Thanks,
Prasad,
Avatar of Leon Taljaard
Leon Taljaard
Flag of South Africa image

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
Avatar of Prasadkosana
Prasadkosana

ASKER

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

User generated imageThe 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.

User generated imageHere you can set the schedule that it will actually fire off

User generated imageAnd 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
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
ASKER CERTIFIED SOLUTION
Avatar of Leon Taljaard
Leon Taljaard
Flag of South Africa image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Thanks Leon... It really helps