question

Deborah-8872 avatar image
0 Votes"
Deborah-8872 asked Criszhan-msft edited

Sql sever credentials issue , i can no longer edit, modify jobs

I had used my credentials to create a job on a server and the job defaulted to using my login but recently my credentials was changed because my status changed in the company then my credentials stopped working, I can no longer modify these jobs but i can see them , i can script them but i cant edit them any longer.What should i do.

sql-server-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

i cant edit them any longer

""Can't edit" means what in detail? Do you get an error message and if, which one?



0 Votes 0 ·

1 Answer

Criszhan-msft avatar image
0 Votes"
Criszhan-msft answered Criszhan-msft edited

Hi,

I can no longer modify these jobs but i can see them , i can script them but i cant edit them any longer.

It seems that your login does not have enough permissions to modify the job in SQL Server, usually you need to have the following roles in the MSDB database: SQLAgentOperatorRole, SQLAgentReaderRole, SQLAgentUserRole.

Or the user must be a member of the sysadmin fixed server role to modify jobs not owned by itself.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.