Have setup various jobs in Rundeck. Want to monitor the same using ITRS Geneos. We tried writing queries using execution and scheduled_execution tables but the scheduled_execution has lot of variance in scheduling e.g. it can have 1-5 also and MON-FRI also for the same scheduling making it difficult.
What we want to monitor: 1. whether there are any failed executions 2. whether any job is running more than its average execution time 3. whether the job is running more than its scheduled time i.e. if job is scheduled to run every 5 mins - we should get alerted if its running more than 5 mins.
Please note - I understand we can do this using email alerts directly via rundeck but want to use ITRS Geneos so looking for some query or API reference which might be helpful.
Please suggest if any solution is available. Thanks.