Search code examples
sql-serversql-server-2012sql-agent-job

Cannot Edit Sql Agent Job Step in SQL Server 2012

I use SQL Server 2012 BI edition.

User has the following roles in the MSDB database:

  • SQLAgentOperatorRole
  • SQLAgentReaderRole
  • SQLAgentUserRole

The user is still NOT able to edit a step in the job to change some parameters. What am I missing?

More details 01:

I have Admin permissions on the BI box. A user needs to run a job when it is required & change configuration parameters when it is required. User is able to successfully run the job, but he cannot edit the step in the job. The button is called View instead of Edit when user looks into properties of the job.

Solution

  • I have finally found the answer on MSDN. User must be a member of the sysadmin fixed server role to modify the jobs that he/she did not create.

    http://msdn.microsoft.com/en-us/library/ms190948.aspx#Security