I have a requirement to get alerts on orchestrations if it runs more than 30 minutes. I looked at SCOM and came to know that there is no built in rule to get alert on this scenario, I need to create a custom rule with sql queries. Is there any sample I can refer on how to create custom SCOM rules for BizTalk orchestration monitoring ?
Can you explain a bit more on what the actual requirement is?
Specifically, exactly what condition could cause an Orchestration to run longer than 30 and exactly what constitutes 'running'.
It's not necessarily wrong to query the DTA database (never, ever query the MessageBox) for this but there may be a better way.
You have two options:
- You can configure SCOM to monitor for suspended Orchestration instances. By this way you know the orchestration in question is not completed.
- You can configure rules to check whether any orchestration instance is taking more than configured amount to time to complete.
Some directions for creating alerts may...
For suspended Orchestration instances suspended alerts - you can configure this alert looking for an event log entry. When BizTalk orchestration is suspended, its logged with Orchestration name.
For long instance is taking more than configured amount to time, i think there is rules alert available as part of MP, but I am not sure. If you not you can create a new rule.
For authoring SCOM rules/monitor, its better to post this question on how to configure the above mentioned like rules in the following forums. More SCOM autors vists these forums, you might get some step-by-step guidance.
Hi Ann ,
Your requirement need more input here because I don't think SCOM is the choice to get automated alert in case your process is running more than 30 min . There may be business cases ,correlation on ports ,Orchestration waiting for the messages to proceed and like wise . You can Query DTA DB only incase your transaction is completed or in inactive state .For long running transaction i dont think you have option to create automated alert ,instead of this you can trigger a message from Orchestration if it taking much time and define a generic Orchestration responsible for sending email . It all depends on your requirement
Thanks
Abhishek