OO 10.70 - DB Query to extract all scheduled flows from OO DB?
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.
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