October 1, 2009 at 10:35 pm
Hi, I'm having an interesting permissions problem in SQL2005 at the moment.
When I am logged into our SQL Server from my local client I am able to see the jobs I have previously setup, and I am able to open the properties window. However, when I go to edit the job steps, they do not display and therefore do not allow me to edit them.
Our server uses windows authentication and I am told by our network guys that my access has not changed in the past two months. However, during this time, where I used to be able to see job steps, I now can't. Instead, I have to log into our server as admin to do this.
I'm assuming that this has to be a permissions issue. If someone could fill me in on what access I need to be able to edit jobs rather than just being able to view them, I'll run off to our server and fix it! I have actually enabled sa access to my windows login, and I still don't seem to have permissions to edit job steps. I think that's rather odd.
October 7, 2009 at 7:35 pm
First thing to do is validate your permissions. You can execute the function sys.fn_builtin_permissions to determine what they are. Next, confirm you are a member of one of the SQLAgent roles in msdb.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply