To find the source of the problem I've done the following
exec master.dbo.xp_cmdshell 'dir c\' : no problem
exec master.dbo.xp_cmdshell 'c:\testdir.bat' (where testdir.bat contains an
"mkdir c:\test" command) : no problem
I put the dtexec command with all it's parameters in a testdtexec.bat file
on the server and executed it from the server: no problem
When I then run the command:
exec master.dbo.xp_cmdshell 'c:\testdtexec.bat'
-> a "cmd" process is started (with a user that has admin priv)
-> a "dtexec" process is started (with the same user runs sqlagent)
and then it hangs forever
Any hints would be appreciated