select CHANGEUSER, CCCORACTIV from sapsr3.t000 where mandt='900'

This will return an '1' or '2', if it is a 1 then I was it to alarm.

The query works and changes if the SAP client status is changed. But if I set and alarm on the query then it only works once and then seems to delete/disappear. So then it does not work.

Any one have any ideas why this happens ? the query continues to work, but when it now switches from a 1, to a 2 then there is no Configured Alarm to be triggered.

thanks for any feedback

lee