ability for alert to trigger a script to be ran

Our engineers has asked for the ability to run a script ( groovy script) when an alert triggers. Example of use case: Given a database, They want to be able to get a snapshot of the processlist w...