January 28, 2016 at 12:33 pm
Hi,
in my machne SQL server having 2014 edition and i have privileges of SQLAgentUserRole,SQLAgentReaderRole,SQLAgentOperatorRole.i have getting problem is when i updating any job the job is changing after changing it is not saving .it is throwing error.
can anyone resolve this issues
January 28, 2016 at 1:16 pm
Can you check who is the job owner?...your account should be the job owner to be able to modify the respective job with these role assignments. If you want to edit the jobs which are owned by different accounts (for eg "sa"), you should be a member of sysadmin server role.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy