Alert on non-SAP DB does not fire.
We're running SBO 8.82 PL12. I have created a query against a non-SAP db (below) that returns records as expected when run in SBO. However, the alert tied to it does not seem to fire. I've tried different frequencies with no luck. OALT records the next date properly one time. OALR seems to have the proper data including the message data. It is just never delivered, either via email or internally. Other alerts are working.
SELECT LA.SUBJOBID, LA.EMPLOYEEID, LA.EMPLOYEENAME, LA.TIMEIN, LA.TIMEOUT
FROM MobileFrame.dbo.OM_LABOR LA
WHERE datediff(HOUR, LA.TIMEIN, GETDATE()) > 16
AND LA.TIMEOUT is NULL
AND deleted_by = -1
Is there a particular problem with non-SBO databases? A workaround?
Any help appreciated.
To document what is perhaps the obvious, a stored procedure on the B1 database may refer to and take data from another, non SBO database. This works fine.