Alert on non-SAP DB does not fire.

[Former Member]

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

[Former Member · Accepted solution]

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.

[Former Member]

Hi,

B1 alert may only work for the data inside B1 database. There is no option for the alert to be based on other db.

Thanks,

Gordon

[Former Member]

Thanks for the quick answer Gordon.  I'm sorry to hear that since the query works so well but it is what it is...I won't keep fighting with it.

Regards,

Scott