469,133 Members | 1,127 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,133 developers. It's quick & easy.

SQL Server Agent has no Access to Path

32,164 Expert Mod 16PB
SQL Server 2000.
MS Windows 2000.

My server has recently stopped using (lost access to) the Path environment variable for jobs run by the SQL Server Agent.
I have restarted the services as well as the whole server but nothing allows the SQL Server Agent to have access to the Path again.
I know the problem is the path as I am running a DTS job using DTSRun.Exe. When I specify the full path for DTSRun.Exe it works ok, but when I simply specify DTSRun, it doesn't.
The command run is :
Expand|Select|Wrap|Line Numbers
  1. DTSRun /S(Local) /E /NVectaCust
The error reported is :
Executed as user: MyDomain\SQLAdmin. The process could not be created for step 9 of job 0x58D606D25DFF2A4F96F11AA5D93B840B (reason: The system cannot find the file specified). The step failed.
This confused me until I realised it was referring to the DTSRun.Exe file. I tried a fully specified reference and it worked (It also worked when I ran the same command from a simple CMD.EXE command prompt).

If this is known behaviour and, more importantly, if anyone knows a fix to make it work correctly again, I'd be very interested to hear about it. In the mean time I will update all my job steps to hold the fully specified command names. Not really looking forward to that - it's not tidy and it's not logical. I hate mess.
Dec 10 '07 #1
0 892

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

5 posts views Thread by Matt | last post: by
60 posts views Thread by Fotios | last post: by
7 posts views Thread by Trevor Best | last post: by
8 posts views Thread by bryan | last post: by
1 post views Thread by CARIGAR | last post: by
1 post views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.