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.
| Author |
Topic |
|
getur.srikanth@gmail.com
Yak Posting Veteran
77 Posts |
 Posted - 2009-09-24 : 13:45:37
|
I am running two jobs simultaneously on SQL Server using psexec.exe. I gave remote server execution like this c:\pstools\psexec.exe \\serverAddress -u userid -p password C:\PROJECTS\AddSPNewUsers\AddSPNewUsers.exe Now problem is both jobs status showing me (Executing: 1 step name) always. It is never coming back.If I run same on command it is working. Only it is not working on SQL Job. Anybody have idea what is the problem? |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-09-24 : 14:35:16
|
My only idea is if the AddSPNewUsers.exe needs some input from a user (dialog via GUI) then it will never come back because no user can see this dialog...
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
getur.srikanth@gmail.com
Yak Posting Veteran
77 Posts |
Posted - 2009-09-24 : 15:07:17
|
| There is no input to that exe. I can execute that from command line. Only it is not working from SQL job. |
|
|
|
|
|
|
psexec.exe keep on running on SQL job??