I want to configure one script like it should send an Alert Message to my mail.
I have these Requirement: In one of my Production database some queries are running more than 2 or 3 hrs, some queries more than 1hr.
So my requirement is i want to get an Alert message, when any of the queries running more than 15 mins or 30 mins. I should get an alert in my mail box.
Please share your ideas or any scripts that full-fill my requirement.
Thanks in advance.