Post reply

Maintenance plans + Multiserver administration

  • February 6, 2009 at 1:51 pm

    #134328

    I'm experimenting with MSX and TSX. I have my MSX setup, and it's talking to a couple of TSX servers. I can create a maintenance plan, specify some of the TSX as targets, save it all. A few minutes later, I check back, and on the TSX, the agent job that runs the maintenance plan has been downloaded, but it does not get the maintenance plan itself. This of course means when the TSX tries to execute the maintenance plan, it does not work because the job essentially says "execute this maint plan", but the maint plan is not there.

    Am I missing a step here? Or is this by design? If it can't automatically send the maint plan over to the TSX, what's the point?

  • February 6, 2009 at 2:34 pm

    #939803

    Nevermind, I figured it out finally. Since different domain accounts run SQLAgent on the different servers, I had to give those accounts the db_ssisoperator role on the master. Now it's grabbing the maint plans as well.

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

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