April 1, 2009 at 3:10 pm
Though i am assigned to
dts adminrole,SQLagentOperatorrole,AgentReader,AgentUser on msdb but still i cant edit my own job. after creating the job and saving it thats it, i cant go back and edit the job.
is there any other permissions setting i have to look.
April 1, 2009 at 4:59 pm
No, that should be enough if you are the owner of the job you should be able to modify the job and also a sysadmin can.
April 2, 2009 at 7:29 am
still ican not edit my own job even after creating a new one and save it.
how do i troubleshoot this, its urgent for me.
thanks
April 2, 2009 at 7:31 am
what is this dts admin role?
I think your permissions are overkill ... u require less than what u have ...
ask some admin to check any denied permissions. ...
April 2, 2009 at 7:47 am
Yes may be you could try that just with the SQLAgentOperator role and dts admin role. without the User and Reader role- you don't need these if you have the operator role.
April 2, 2009 at 10:46 am
I think I may be trying to figure out the same thing. I'd like to bring up the gui to edit a job, the same screens I get when I create the job in the first place. i.e. when you right click a database, click import or export and a gui comes up and you select the database, what data you want transferred, etc and it guides you through the whole process. I can't get that kind of thing back for a job I have already created, is there any way to do this?
Thanks
April 2, 2009 at 2:16 pm
Have you confirmed you are still the owner of the job?
April 2, 2009 at 2:33 pm
Not the owner, but I'm an administrator. Do I need to be the owner of the job?
April 2, 2009 at 2:39 pm
sbrown (4/2/2009)
Not the owner, but I'm an administrator. Do I need to be the owner of the job?
Administrator by default is the owner of all jobs.
April 2, 2009 at 3:57 pm
That's right sysadmin is by default owner of all the jobs. These are local jobs right?
April 3, 2009 at 6:36 am
Krishna Potlakayala (4/2/2009)
sbrown (4/2/2009)
Not the owner, but I'm an administrator. Do I need to be the owner of the job?Administrator by default is the owner of all jobs.
When I right-click the job and check the properties it is another admin's user id, although I am an admin and should have full permissions to edit anything on the db.
edit: I didn't mean I was logged in as "Administrator", just that I have administrative privelages. Thanks.
April 3, 2009 at 6:37 am
SA (4/2/2009)
That's right sysadmin is by default owner of all the jobs. These are local jobs right?
I'm not sure I understand the question. The jobs are local on my sql server, if that's what you mean. It's not a job on another server somewhere else.
April 3, 2009 at 6:44 am
sbrown (4/3/2009)
Krishna Potlakayala (4/2/2009)
sbrown (4/2/2009)
Not the owner, but I'm an administrator. Do I need to be the owner of the job?Administrator by default is the owner of all jobs.
When I right-click the job and check the properties it is another admin's user id, although I am an admin and should have full permissions to edit anything on the db.
edit: I didn't mean I was logged in as "Administrator", just that I have administrative privelages. Thanks.
Humm...I am not so sure about this. Can you login as an administrator and see? I know it might be a bit in convienient can you test it on your test server?
April 3, 2009 at 7:31 am
Your not on a cluster by anychance and the cluster has rolled to your standby...i had the same issue tried to edit a job and couldn't it was because the cluster had rolled on to the standby. So i had to log into that node server to get to edit the job.
April 3, 2009 at 7:37 am
If you connect to the cluser using the Virtual name or IP you should be ok in that case right? You should not have to disconnect and re-connect, which should be the way one should be logging in anyway.
Viewing 15 posts - 1 through 15 (of 17 total)
You must be logged in to reply to this topic. Login to reply