In our application with have an SQL Agent Job with an SSIS-Package (.dtsx).
In this SSIS-Package, there are an process step (Execute Process Task) with Executable: "taskkill.exe" and Arguments: "/F /T /IM abc.exe".
The SQL Agent runs under a technical user 'TecAbcUser' and the Job Step Run as: "SQL Server Agent Service Account".
The technical user "TecAbcUser" has following additional rights:
- act as part of the operating system
- replace process level token
- log on as a batch job
When I run the job in SQL Server Management Studio 2008 R2 over job contextmenu with "Start Job at Step..." the dtsx package will be executed, but taskkill.exe wouldn't be started and no errors will be shown in job history.
But there are shown the following error in Event Viewer "System":
"Application popup: taskkill.exe - Application Error : The application was unable to start correctly (0x0000142). Click OK to close the application"
If I start the SSIS-Package (dtsx) directli per double click on this dtsx file, Execute Package Utility (DTExecUI.exe) will be started and after clicking on Execute, taskkill.exe will be started and no error is thrown to Event Viewer logging.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.