Skip to Content
avatar image
Former Member

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

Alert_001.png (30.3 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    May 15, 2015 at 09:06 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 11, 2014 at 07:54 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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