Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Check if Application is running and close it?

Author  Topic 

Bill_C
Constraint Violating Yak Guru

299 Posts

Posted - 2011-03-08 : 04:08:59
Does anyone know how to check if Excel is running on the server and if so close it?

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2011-03-08 : 04:40:58
Wow...I'd object to even having Excel on a server but once you have it you could probably use powershell and an execute script task:

powershell "Get-Process notepad | Stop-Process"

This will stop all instances of notepad. You might run in to permission issues though...

- Lumbago
My blog-> http://thefirstsql.com/2011/02/07/regular-expressions-advanced-string-matching-and-new-split-function-sql-server-2008-r2/
Go to Top of Page

Bill_C
Constraint Violating Yak Guru

299 Posts

Posted - 2011-03-08 : 08:45:57
Thanks.
Go to Top of Page
   

- Advertisement -