Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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

1 Answer 1

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

 
discard

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.