November 20, 2008 at 11:46 am
I need to create a role to manage the jobs: view, start, stop, add job/step, delete job/step, etc, without giving the role sa privileges. I've tried to create a role and give it dbo on the msdb database but that doesn't do the trick. I am not able to view the jobs through enterprise manager even with dbo on the msdb database.
Any help is appreciated.
Thank you
November 20, 2008 at 11:58 am
Search BOL for SQLAgentOperator Role.
November 20, 2008 at 12:14 pm
From my understanding that role only exists in 2005 along with SQLAgentUserRole and SQLAgentReaderRole. I need this role for 2000.
November 20, 2008 at 12:38 pm
My bad. Try looking here:
http://www.eggheadcafe.com/software/aspnet/30519822/rights-to-execute-jobs.aspx
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply