Post reply

How to change the ownership of Maintenance plan?

  • January 31, 2009 at 10:03 am

    #218124

    When we create Maintenance plan on SQL Server, by default the jobs are owned by the Windows login. After creating the maintenace plan is there way to change the ownership.

    Sivaprasad S - [ SIVA ][/url]http://sivasql.blogspot.com/[/url]

  • February 1, 2009 at 11:02 pm

    #936249

    Hi,

    You may go to the Job being created by that Maintenance plan and there go to the Job properties. Under 'General' Tab, you will find a field 'Owner'. Change it to the desired name.Click 'Apply'--> OK

    ----------------------------------------------------------------
    **"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **

  • March 22, 2010 at 10:20 am

    #1137674

    Is there a way to set job ownership in a maintenance plan to a group, instead of a single account?

  • March 23, 2010 at 9:05 am

    #1138283

    Yes - You can setup a job to use a Windows group.

  • March 23, 2010 at 7:04 pm

    #1138635

    Actually, we tried that, but we got an error. Can you post some sample syntax?

  • March 24, 2010 at 6:54 am

    #1138867

    You can just change the owner on the Job Properties screen to domain_name\group_name. Of course the group has to have the correct server role - i.e. sysadmin.

    We don't use groups for job ownership, but it can be done. Although, I'm not sure why you'd want to.

  • March 24, 2010 at 7:43 am

    #1138923

    shew (3/23/2010)

    Actually, we tried that, but we got an error

    post your error

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

Viewing 7 posts - 1 through 6 (of 6 total)

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