Post reply

agent runs maint. plans as invalid user

  • September 22, 2004 at 9:45 pm

    #86458

    I have a mainenance plan that backs up all databases nightly on SS2K. My machine name changed after SS2K was installed and the plan stopped working. From looking at the sql agent job created by the maint. plan, it appears that the job is running as OLDNAME\Administrator instead of NEWNAME\Administrator.

    I've done the sp_dropserver / sp_addserver fix.

    Enterprise manager allows me to select a different user for the job, but if I change the user, click OK, then click properties again, the old (invalid) user is displayed.

    Does anyone know how to fix this? Manually backing up dozens of databases sucks.

    Thanks in advance,

    -dave

  • October 1, 2004 at 8:26 pm

    #525108

    You may need to drop the job and recreate it. Also, the job may think it is owned by the old server name and may not allow changes until you go into msdb.dob.serverjobs and change the owning server.

    Wes

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply