Home Forums SQL Server 2008 SQL Server 2008 - General Permissions to edit SQL 2008 R2 jobs RE: Permissions to edit SQL 2008 R2 jobs
Chuck Hottle
SSCarpal Tunnel
Points: 4777
More actions
January 5, 2012 at 12:55 pm
#1429310
I think they need to own the job in addition to being a member of the applicable msdb role. I don't think there is any way around having them own it.
http://msdn.microsoft.com/en-us/library/ms188283.aspx