Need help with getting runbook to loop over 3 runs

Question

I have a runbook that monitors the SSRS service on our SSRS servers. We would like to set it so that it runs but only emails if there have been 3 failures in a row for the service. I am new to Orchestrator and am not sure how to go about setting this up. I have attached the export of the job to the post and am wondering if anyone would be able to help me figure out what to do to get this to work the way we envision.

129986-ssrs-monitoringois-export.txt

Answer 1

Hi @TBingeman ,

Re-Design your Runbooks.
One with the "Run .Net Script" Activity which checks and tries to start the service. In the "Initialize Data" Activity define the Parameter ComputerName. And in properties of this Runbook define the "RerturnData" whether an EMail is needed.

In the Monitoring Runbook invoke the first one an pass the ComputerName from the "Read Line" Activity.

Enable Looping for the "Invoke Runbook Activity". (he delay is in seconds).

Define in Exit condition in the Loop if email is not needed an the max attempt of 3 (common published data).

130115-ssrs-monitoring-stefan-ois-export.txtSend the Mail if the Runbook still returns EMailIsNeeded after 3 attempts.

Regards,
Stefan

Answer 2

So, set "Monitor/Date time" to trigger every 15 Minutes. And the delay in the loop to 300 seconds.
Orchestrator is a great product for IT-Processs-Automation. For Monitoring purposes i would prefer System Center Operations Manager (SCOM).
Good luck!
Stefan

Answer 3

Hi @TBingeman ,
yes, Orchestrator is designed for IT-process-automation and not for Monitoring. With Monitoring Tools like SCOM the monitors run on an local agent, here it runs on the Runbook Server(s).
Anyway, if you want the solution for Orchestrator with concurrent jobs. I think you need to Runbooks:

• One with "Monitor Date/Time" and "Invoke Runbook" with each line.
• The second with a "Job concurrency" of the number of Servers that should be checked, invoked by each line. And the loop I tried to describe above
• The third perhaps also with a "Job concurrency". which checks the Service an tries the restart.

I will upload an export here.

If you really want it like in the export check: https://learn.microsoft.com/en-us/system-center/orchestrator/how-to-configure-runbook-throttling?view=sc-orch-2019

Regards,
Stefan130819-ssrs-monitoringois-export.txt