[njams] how the njams_t_monitor_main status works
16 September 2015
nJAMS/BWPM has a rather complex system for determining the status of a process. Although all of this is easily accessible through the GUI, you sometimes need to go directly to the database for some further reporting. So here the select to get the calculated state of the GUI.
result:
jobstart | deployment | process | status |
---|---|---|---|
15-07-16 13:57:00 | C1_Services | O/C/Starter_C1_SendOrder.process | success |
15-07-16 14:04:00 | ESB_Engine | O/O/Starter_OrderTransformationService.process | success |
15-07-16 14:05:00 | SAP_Services | O/S/Starter_ReceiveOrder_SAP.process | success |
15-07-16 14:08:00 | ESB_Engine | O/O/Starter_OrderTransformationService.process | error |
15-07-16 14:09:30 | ESB_Engine | O/O/Starter_OrderConfirmationService.process | warning |
15-07-16 14:10:30 | C1_Services | O/C/Starter_ReceiveOrderConfirmation_C1.process | success |
15-07-16 14:11:30 | C1_Services | O/C/Starter_ReceiveOrderConfirmation_C1.process | success with warning |
15-07-16 14:59:30 | SAP_Services | O/S/Starter_SAP_SendOrderConfirmation.process | success with error |
15-07-16 15:00:00 | DWH_Services | O/D/Starter_ReceiveOrder_DWH.process | success |
15-07-16 15:02:00 | C1_Services | O/C/Starter_C1_SendOrder.process | success |
all the stuff shown here works with version 3.1, no clue about other versions of the software