March 9, 2005 at 2:12 am
Hi
Please can anyone help. I had to reload SQL Server 2000 with service pack 3a onto a new server. I restored master, model, msdb and user databases and all appeared fine.
When my sheduled jobs try to run, I get the following message -
Executed as user: EDPCLP02D\SYSTEM. The process could not be created for step 1 of job 0xBCADB948D281DF4BA1A9D77442BA5203 (reason: The system cannot find the file specified). The step failed.
It appears that the scheduler can't find the DTS package. I tried creating a new DTS package, scheduling it and running it. Same problem.
Any help would be appreciated.
Thanks
Philip
March 9, 2005 at 4:05 am
did you reload sql databases on new server, meaning having another name?
IF so, first check BOL on sp_dropserver and sp_addserver.
You can also check msdb..sysjobs table. It keeps some informationabout the server it's running jobs on.
hth
JP
March 9, 2005 at 11:35 pm
This error is returned when a CmdExec step type can't find the referenced executable. In the case of scheduled DTS packages this is dtsrun.exe. Check your PATH environment variable -- I'm betting the directory containing dtsrun.exe isn't in there. The default is X:\Program Files\Microsoft SQL Server\80\Tools\Binn. If it's not, go ahead and add it and it should resolve the issue.
Greg Gonzalez
sqlSentry
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply