Dondon22 Respected Contributor.
Respected Contributor.
276 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
Outstanding Contributor.. JarodMB Outstanding Contributor..
Outstanding Contributor..

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

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

0 Likes
Dondon22 Respected Contributor.
Respected Contributor.

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

As simple as this:

FLOW_UUID, FLOW_NAME, SCHEDULED_DAY, SCHEDULED_TIME, STATUS

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

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

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.