February 1, 2009 at 11:02 pm
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
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
Yes - You can setup a job to use a Windows group.
March 23, 2010 at 7:04 pm
Actually, we tried that, but we got an error. Can you post some sample syntax?
March 24, 2010 at 6:54 am
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
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 6 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply