As every BP is also a SQL table, you can select active processes which are older than 1 day with this query:
SELECT ID, %SessionId, %SuperSession, %TimeCreated, DATEDIFF('day',%TimeCreated, CURRENT_TIMESTAMP) AS DaysOld
FROM <business_process_table>
WHERE DATEDIFF('day', %TimeCreated, CURRENT_TIMESTAMP) > 1
AND %TimeCompleted IS NULLAs BO messages also get logged, you can check Ens.MessageHeader table for message processing time.
- Log in to post comments
