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