Link to home
Start Free TrialLog in
Avatar of Enhanced Support
Enhanced Support

asked on

Reading Task Manager Processes

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.

Any ideas?

Thank you.
Avatar of randy_knight
randy_knight

Is this 2005?  I would probably use SSIS and use a VB.NET script to access running processes.  I don't know it fof the top of my head but there has to be an east .NET framework way to check running processes?  

It it's SQL 2000, you could do the same thing in DTS with an ActiveX Script ... would need to use WMI but that's not too hard either.

Avatar of Enhanced Support

ASKER

The client is actually using MSDE but I can see that this could be useful for other applications in future.

I would have thought that as SQL Server can obviously see the Task Manager entries to kill the task, surely it should be able to query them? The whole point is to monitor when a program is no longer running from within SQL Server itself rather than building another program to act as the monitor.
ASKER CERTIFIED SOLUTION
Avatar of randy_knight
randy_knight

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks, Randy - think that will probably do what we need. I'll google the rest !

Mark