Change Owner of a Job and Maintenance Plan?

  • Is there a way to change the Owner of a Maintenance Plan? Please explain. I see there is a way to change the Owner of a Job by going to the Job Properities-Maintenance Plan Screen. Or would changing the Owner on the Job Properities-Maintenance Plan Screen also change it on the Maintenance Plan? We are running SQL Server 2005 on Windows Server 2003 R2 Operating System.

    Thanks in advance, Kevin

  • I'm not sure how you'd change the owner. Export the plan, import as the other user?

    Changing the owner on the job should affect that, but I guess is you edited the maintenance plan, the owner of the job would be changed to the maint plan owner.

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

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