Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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.

The query:

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

The alert:

Is there a particular problem with non-SBO databases?  A workaround? 

Any help appreciated.


TIA,

Scott

Tags:
Former Member
Former Member replied

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.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question