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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 sql job problem

Author  Topic 

fqiao70
Yak Posting Veteran

52 Posts

Posted - 2003-05-12 : 15:54:20
I created a job on SQL that executes a .exe file every night. I double click to execute this file on server, there is no problems. but when I start the job, it's just executing it for a long long time. what problem it might be happened? Thanks

chadmat
The Chadinator

1974 Posts

Posted - 2003-05-12 : 16:06:33
Try logging in as the SQL Service/SQLAgent user and run the .exe.

Does the EXE access any remote shares or files? The exe will run under your security context when you double click it, but will run under the context of the service account when it is scheduled. It is most likely a permissions issue.

-Chad

http://www.clrsoft.com

Software built for the Common Language Runtime.
Go to Top of Page
   

- Advertisement -