Saturday, April 18, 2015

How To Find The List Of Scheduled Workflows Which Gets Unscheduled After A Failure/Succeeded?

How To Find The List Of Scheduled Workflows Which Gets Unscheduled After A Failure/Succeeded?



You could do this by executing a query against the underlying domain database table "OPB_WFLOW_RUN" for the date or dates
and look at the column "RUN_STATUS_CODE". Here is how to interpret this column:

1= 'Succeeded'
3 = 'Failed'
4 = 'Stopped'
5 = 'Aborted'
6 = 'Running'
15 = 'Terminated'

There may be other values but I do not know them all...these are the important ones.





:)
.




No comments:

Post a Comment

SNOWFLAKE Interview Questions 2025

  1️ ⃣ Choosing the Perfect Size of Virtual Warehouse To select the right size (X-Small to 6X-Large), consider: Data Volume ...