Re: SQL agent jobs fail after upgrading windows2000 to windows2003

From: Russell Fields (RussellFields_at_NoMailPlease.Com)
Date: 02/26/04 

Date: Thu, 26 Feb 2004 16:35:10 -0500

Mike,

It sounds like you are executing something other than T-SQL in your jobs.
The 'cannot find the file' indicates that the job is reaching out into the
file system (vbscript, DTS, xp_cmdshell, etc) and has no rights to the
location specified.

You need to examine the operating system and domain rights that have been
granted to SQLAdmin (which I assume is a login and not the fixed system
role).

Russell Fields
"mike wang" <anonymous@discussions.microsoft.com> wrote in message
news:18F70C36-BB93-4B3C-A0B2-F83C7E3D59EB@microsoft.com...
> I have a SQL2000 SP3a server on Windows2000, just upgraded it to
windows2003.
> After that, some SQL agent jobs will no longer run. The error message in
the detail says:
> Executed as user: SQLAdmin. The process could not be created for step 1 of
job 0x45D6E79882DE1B4D86978C809F3678C2 (reason: The system cannot find the
file specified). The step failed.
> No idea what does this mean? Could someone give me a hand?
> Thanks in advance.

Relevant Pages

  • Re: At job not executing
    ... >output of that command will go in the user's email. ... while crontab jobs are correctly executed on ... >possible that cron keeps subsequent at jobs in the queue if the limit ... not just not executing. ...
    (comp.unix.sco.misc)
  • Re: TSQL to find all running SQL Agent jobs
    ... executing. ... you can refer to system tables like sysjobs* for making the query. ... > list all jobs that are currently running ...
    (microsoft.public.sqlserver.programming)
  • How to restart executing jobs after server reboot?
    ... the server maintenance people reboot the server? ... After the reboot, I ... have been manually restarting any jobs that were executing or retrying. ...
    (microsoft.public.sqlserver.dts)
  • Re: How to restart executing jobs after server reboot?
    ... Have a job that starts at agent startup. ... In your jobs you create add a step at the start that inserts into a table the time it started. ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... > have been manually restarting any jobs that were executing or retrying. ...
    (microsoft.public.sqlserver.dts)
  • Re: User cannot print
    ... Is there any error message or the jobs just go to the queue and are not ... "Jerry Fortenberry" wrote in message ... > Windows XP Pro...One user cannot print to a local printer. ...
    (microsoft.public.windowsxp.print_fax)