Highlighted
Respected Contributor.
Respected Contributor.
344 views

OO 10.70 - DB Query to extract all scheduled flows from OO DB?

Hello!

Anybody who knows the query to extract all scheduled flows from OO DB?

I need this to create automated report to my management.

Thanks in advance.

Don 🙂

In IT there is no Magic, just Logic ^_^
0 Likes
3 Replies
Highlighted
Outstanding Contributor.. Outstanding Contributor..
Outstanding Contributor..

Can you provide more detail about the desired detail in the report? including data age per report and report production frequency

0 Likes
Highlighted
Respected Contributor.
Respected Contributor.

As simple as this:

FLOW_UUID, FLOW_NAME, SCHEDULED_DAY, SCHEDULED_TIME, STATUS

In IT there is no Magic, just Logic ^_^
0 Likes
Highlighted
Outstanding Contributor.. Outstanding Contributor..
Outstanding Contributor..

take a look at the OO_TRIGGERS table
convert the timestamp to datetime 

select dateadd(ms, [NEXT_FIRE_TIME]%(3600*24*1000), dateadd(day, [NEXT_FIRE_TIME]/(3600*24*1000), '1970-01-01 00:00:00.0')) as NEXT_FIRE_TIME_Calc

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.