Cannot Edit Sql Agent Job Step in SQL Server 2012

Question

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.

how can you tell that user is not able to edit? you click and get some error? or maybe some button is missing? or...? please add some detail. — Paolo
– Paolo, Commented Sep 30, 2014 at 14:38
I have added more details. What is wrong with the question? I believe I was down-voted for no reason. — BI Dude
– BI Dude, Commented Sep 30, 2014 at 14:50

BI Dude · Accepted Answer · 2014-09-30 16:52:41Z

4

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

answered Sep 30, 2014 at 16:52

BI Dude

2,0768 gold badges43 silver badges73 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Dave.Gugg Over a year ago

Warning - Giving sysadmin to a user mean they can do ANYTHING on the sql server. This is not a good solution, unless you don't want to be a DBA anymore.

Shan · Accepted Answer · 2017-04-07 18:25:40Z

2

You can use the below stored procedure to update the jobs in SQL Server Agent

USE msdb ;  
GO  

EXEC dbo.sp_update_jobstep  
   @job_name = N'Weekly Sales Data Backup',  
   @step_id = 1,  
   @command = //your updated command ;  
GO

Source - https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-update-jobstep-transact-sql

answered Apr 7, 2017 at 18:25

Shan

5885 silver badges18 bronze badges

Collectives™ on Stack Overflow

Cannot Edit Sql Agent Job Step in SQL Server 2012

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related