July 7, 2004 at 4:54 am
Hi
I have made a packages that works nice when I execute the package but when I am doing a schedule job then doesnt it work.
This is the error code:
"The process could not be created for step 1 of job 0xB4B1D2612F8DC04194B919CFBE45923A (reason: The system cannot find the file specified). The step failed."
I have tried to change the permissions and nothing seems to help.
Can anyone explain why it doesnt work
/Kent
July 7, 2004 at 5:22 am
Unfortunately, without understanding what step 1 does I am only guessing as to what the real issue is.
When you run the package yourself it runs from your PC and under your login security.
When you schedule a package it runs from the SQL server and under the "Run as" that you set in the package.
I would make sure that the userid that the package is running under can get to wherever it needs to go i.e. windows directories, databases, etc....
Good Luck
Good Hunting!
AJ Ahrens
webmaster@kritter.net
July 7, 2004 at 8:08 am
July 7, 2004 at 8:28 am
Is there a way to check wich userid that are used?
Is there any differenses when I use a domainuser (\\domain\user) as the owner of the job.
/kent
July 7, 2004 at 5:31 pm
When you open the scheduled job there should be on the first screen a job owner... that is who is running the DTS package scheduled.
When you manually run the package it uses your authentication.
Good Hunting!
AJ Ahrens
webmaster@kritter.net
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply