We have several process flows which run on calendar (e.g 8 each day).
Would like to schedule some process flows based on events (e.g arrival of a file, change in status of record in table (.eg form Y to N).
Is this possible in OWB?
If so How?
Never came across a facility like that.
May be you can create another job that runs more frequently looking for the status change. This job can schedule the process flows if a status change was identified.
Not the ideal way; but it's possible to fire a trigger where the status changes occur too to schedule the process flows..
Thanks for update.
What we did is have scheduke which starts at 8.00 p.m. each night.
It has while loop at start which will loop until condition is true or window expired 6 in morning
This works for us.
Such a file watcher capability is now in the Oracle database;
There is an older blog post showing how this can be used with OWB objects (using a package for older releases) below;