Share via

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

Korede D Franklin 1 Reputation point
2021-07-23T14:47:43.387+00:00

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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,823 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Cris Zhan-MSFT 6,626 Reputation points
    2021-07-26T06:45:44.97+00:00

    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.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.