Verified Answers

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

  • State Not Answered
  • Replies reply
    1
  • Subscribers subscribers
    175
  • Views views
    489
  • Users 0 members are here
  • Locked Locked
Related
Options
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

flow

David Valero

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

  • 0

    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'

Resources

Support
Documentation
Learning Services
Partner Programs
Privacy
Compliance
Help
Company
Privacy Policy
Terms of Use
Cookies Preferences
Accessibility
Anti-Slavery Statement
Support
Contact Us
Careers
Code of Business Conduct and Ethics
The opinions expressed above are the personal opinions of the authors, not of OpenText. By using this site, you accept the Terms of Use. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.), Hewlett Packard Enterprise Company, or Micro Focus. As of January 31, 2023, the Material is now offered by OpenText, a separately owned and operated company. Any reference to the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks is historical in nature and the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks are the property of their respective owners.