Background
Example to send an email in case an Operator messages contains a certain text
Instructions
You can do following to send out an email alert in case Operator messages contain a certain text (i.e. "startup failed")
1. in Definitions > Reports create a Report Definition with following SQL text
select om.CreationTime, om.FirstText
from OperatorMessage om
where om.FirstText like '%startup failed%'
Add Parameter Start with value =Time.expression(Time.now('GMT'), 'subtract 2 hours')
Add Selection
2. Create a Jobchain and
- call the Report Definition in Step1
- call System_Mail_Send in Step2 with precondition=JobChainParameters.getOutValueNumber('Step 1, Job 1', 'RecordCount') > 0
3. Submit the JobChain with an hourly interval
Comments
0 comments
Please sign in to leave a comment.