[dba-SQLServer] Re: Sql Job: The System Cannot find the file specified

Francisco Tapia fhtapia at gmail.com
Tue Jul 5 13:43:43 CDT 2005


I found the solution
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q322746

Because of the upgrade somehow the path was not specefied thus the
bogus error...

On 7/5/05, Francisco Tapia <fhtapia at gmail.com> wrote:
> I re-created the DTS, then I re-scheduled the DTS, that job failed w/
> the same error I'm looking at the configuration and it all seems
> normal (I suppose).  The sql server agent is a local admin account. :(
> 
> On 7/5/05, Bott, Bruce - SICA <bbott at simpson.com> wrote:
> > Did you create a new schedule for the (new) job?
> >
> > -- bb
> >
> > -----Original Message-----
> > From: bounce-sql2k-6502234 at ls.sswug.org
> > [mailto:bounce-sql2k-6502234 at ls.sswug.org] On Behalf Of Francisco Tapia
> > Sent: Tuesday, July 05, 2005 10:27 AM
> > To: SQL Server 2k List
> > Subject: Sql Job: The System Cannot find the file specified
> >
> > I have a Sql Server who's hardware was just upgraded, and I noticed that
> > all my sql server jobs which were scheduled DTS jobs are failing (those
> > w/ ActiveX scripts).
> >
> > Windows 2000 Server SP4
> > Sql Server 2000 SP3a
> >
> > Sql Server Agent Login: local admin account
> >
> > Error:
> > Executed as User (xxxx). The process could not be created for step 1 of
> > job 0x..... (reason: the system cannot find the file specified).
> > The step failed
> >
> >
> >
> > Troubleshooting: I re-created the DTS job and the Sql Job, I can run the
> > DTS job manuall w/ success but cannot seem to have it run when
> > scheduled.  what step did I miss?
> >
> > Thanks for your help
> > --
> > -Francisco
> > http://pcthis.blogspot.com |PC news with out the jargon!
> > http://sqlthis.blogspot.com | Tsql and More...
> >
> > ---
> > You are currently subscribed to sql2k as: bbott at simpson.com To
> > unsubscribe send a blank email to leave-sql2k-9078501N at ls.sswug.org
> >
> > -------------
> > See http://www.sswug.org/archives for list archives.
> > mailto:listadmin at sswug.org with list issues.
> >
> >
> >
> >
> > ---
> > You are currently subscribed to sql2k as: fhtapia at gmail.com
> > To unsubscribe send a blank email to leave-sql2k-9078501N at ls.sswug.org
> >
> > -------------
> > See http://www.sswug.org/archives for list archives.
> > mailto:listadmin at sswug.org with list issues.
> >
> >
> 
> 
> --
> -Francisco
> http://pcthis.blogspot.com |PC news with out the jargon!
> http://sqlthis.blogspot.com | Tsql and More...
> 


-- 
-Francisco
http://pcthis.blogspot.com |PC news with out the jargon!
http://sqlthis.blogspot.com | Tsql and More...



More information about the dba-SQLServer mailing list