Operation Orchestration Studio how can I make a flow that every two hours reviews the flows that have been running for more than an hour and sends us an email
Cybersecurity
DevOps Cloud
IT Operations Cloud
If an answer to your question is correct, click on "Verify Answer" under the "More" button. The answer will now appear with a checkmark. Please be sure to always mark answers that resolve your issue as verified. Your fellow Community members will appreciate it!  Learn more
Operation Orchestration Studio how can I make a flow that every two hours reviews the flows that have been running for more than an hour and sends us an email
You can start expanding this query to achieve your objective:
I'm using Oracle database... hope it helps
SELECT
FLOW_UUID,
FLOW_PATH,
CAST(DATE '1970-01-01' + ( 1 / 24 / 60 / 60 / 1000 ) * START_TIME_LONG AS TIMESTAMP) + INTERVAL '+03:00' HOUR TO MINUTE as "DurationMin"
FROM OO_EXECUTION_SUMMARY WHERE
STATUS = 'RUNNING'