SQL JOBs Failing
-
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?
btw, The Sql Server Agent Account is a local windows 2000 account w/ local administrator rights.
-- Francisco
-
who's the owner of the msdb database? It's a tale-tale sign that it's owned by the domain user account you're using for the mssql service. If it is then change it to 'sa'
-
that is owned by sa (dbo) but it turned out to be just as simple...
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q322746
during the hardware change the Path Variable was never updated to reflect the path to Sql Server. I added the Path (..\80\tools\binn).
-- Francisco
-
cool! glad it worked out for you...
-
btw, thanks for taking the time to answer
, it helps to know at least people are reading the posts -- Francisco
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply