This stored procedure is another monitoring utility that can be executed periodically as a sql server agent job.
The procedure checks if there are any open connections, and if there was any recent user activity within a given period of time in a given (or any) database by a given (or any/any except given) login from a certain group of hosts (or any host)via a particular (or any) application.
An error will be raised if the last executed batch occurred earlier than defined in @pThresholdMinutes.
Like the one posted before, the use of the SP is like this: proc_alerts 1,18. This will show the first 18 alerts on the system. OR proc_alerts 20,35 will show from 20 to 35. This lets you manage the list without letting go out of the screen.