Hi all,
I'm looking for a way to run a SQL script at a specific time of day.
Since the jdbc_response probe doesn't have a scheduler I'm struggling for a way to query the UIM DB at midnight, which will total up a value over the last 24 hours.
I've looked into a Lua script, but it's pretty labour intensive for what I need. I could also alert on the value and use alarm.get to bring the value into a Lua script and then post it to QoS, but that seems a little over engineered.
Any thoughts on a more elegant way to achieve this?
Cheers,
------------------------------
CA - UIM administrator
------------------------------