November 18, 2004 at 2:51 pm
Hi everyone,
Is there any way (other than making users sysadmin) to allow users to see, create new jobs, and modify existing jobs in EM? Thanks.
November 18, 2004 at 3:21 pm
November 18, 2004 at 3:37 pm
Wow, thanks for the link. Just what I needed!
March 22, 2005 at 9:30 am
That link doesnt appear active. Is the article available elsewhere?
March 22, 2005 at 11:50 am
Unsupported by MS, but as of SP3, make them members of the targetserversrole in the msdb database. The reason this works is there is a view, sysjobs_view, that allows that role to see the job even if the user isn't the job owner or a member of the sysadmin fixed server role. If you EXEC sp_helptext sysjobs_view you'll see why that is.
K. Brian Kelley
@kbriankelley
March 23, 2005 at 4:16 am
Try this link, or copy and paste the original and add &forumid=5 to the end
http://www.sqlservercentral.com/forums/shwmessage.aspx?messageid=110031&forumid=5
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply