Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a SQL Agent job on a clustered SQL 2008R2 server on Windows 2003 Enterprise. It's an Operating System (CmdExec) step, running an executable. When it runs on schedule, the process does start up, and the job shows as running. However, it never completes the job.

When i run the executable interactively, i.e. I double click it, it runs and it completes its processing in 10 mins or so as expected.

I've monitored the exe with procmon when it hangs, and it logs no errors, it just stops processing (but the exe is still running)

I'm 90% sure this is something to do with the user account running SQL agent, and the local security policy. The account has all the privileges I think it needs - log on as service, log on as batch, etc. I think over the testing period I've pretty much assigned it every right in the policy.

Any ideas why an exe would run fine interactively but fail with SQL agent?

share|improve this question

You need to verify that you can run the command as the user SQL Server Agent runs as:

RUNAS /user:SqlAgentUser <command>

share|improve this answer
Yes, when run interactively as that user, either with runas command or by actually logging in as that user, exe runs properly and processing completes. – matt_p May 1 '12 at 13:12

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.