I recently had a slight problem in which I somehow managed to pause all of our transaction groups, and lost about an hours worth of our history. It’s not a huge deal that we lost an hour worth of data by itself, but it could have been a bigger problem if had gone for a longer amount of time.
The only reason we noticed that they were paused was that we had another alert go off that we tried to look at the historic data for, and noticed that it hadn’t updated for an hour or so.
I have since set an alert to go off if we lose connection to the database (Through the System->Gateway->Database->fsql->Available tag), but this doesn’t tell me if I have groups paused. Is there anyway through a DB tag or similar to tell which groups are paused? I was thinking about maybe making some tags based on the most recent time stamp for each table, but that may not work as we have some Transaction Groups which only evaluate if the value has changed.
Any suggestions would be greatly appreciated.