Reading Task Manager Processes
Posted on 2008-10-29
I see that there is an extended stored procedure within SQL Server called xp_terminate_process which will terminate a process running within task manager. Is it possible to read through the process list to see whether a project is running, not by its PID but by its name?
For example, if I were to have a program called TestApp.exe running which then is terminated, I would like SQL Server to fire an email using Database Mail to alert a user that the program is no longer running. I have the rest of the routine worked out, just not the part that actually reads the entries in the process tab of Task Manager.