Automatically Close Events by KS Name
This SQL stored procedure automatically closes all Open or Acknowledged Events from a specific KS.To install this procedure, open and run it in SQL Management Studio, first ensuring the AppManager database is connected.
The procedure is run by executing the following command in SQL, inserting the relevant description:
exec _CloseEventsByKS '<KSName>'
The stored procedure may be scheduled to run on a regular basis via the SQL Agent.