Hi Everyone,
I have a user / client who created a SQL Job on their dedicated server, so they are set as the job owner, and they have permissions for SQLAgentUser in MSDB, but all of the sudden now, they can no longer edit their job (i.e. Job Steps, etc). We even set the user to SQLAgentOperatorRole, but no dice. They can still see the Job in SSMS, and open it to view the details, but cannot edit anything - it's grayed out.
Anyone know what could be causing this?
(btw, this is SQL 2005, CU9). We have CU9 on all our servers now, which amounts to a few hundred, but this is the only situation like that which we have come across.)
-Ovatvvon :-Q
I have a user / client who created a SQL Job on their dedicated server, so they are set as the job owner, and they have permissions for SQLAgentUser in MSDB, but all of the sudden now, they can no longer edit their job (i.e. Job Steps, etc). We even set the user to SQLAgentOperatorRole, but no dice. They can still see the Job in SSMS, and open it to view the details, but cannot edit anything - it's grayed out.
Anyone know what could be causing this?
(btw, this is SQL 2005, CU9). We have CU9 on all our servers now, which amounts to a few hundred, but this is the only situation like that which we have come across.)
-Ovatvvon :-Q