We would like a report to be triggered when database sessions have blocked for a period of time. We have tried to assocuiate a threshold against the attribute "Blocked Session (Count)" but it does not seem to fire even when we intentially block the database.
What is the best was to achieve something like this?