question

srinivassista avatar image
srinivassista asked

Permission to view SQL jobs

I'm using SQL Server 2017, I need to give developers only to view the jobs (either it is SSIS packages which is scheduled as a job or SP scheduled as a job).
What does edit means:- Double click the job, go to each step and see which package it is referring to and see the configuration/data sources connections for each step. I'm happy if i don't give me rights to run the job/delete the job/ and modify the job.

Any help is really useful, as I need to do this change on production for the developer on Monday.

You may send mail to me at sns_Subash2002@yahoo.com

sql agentjob-editor
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
srinivassista avatar image
srinivassista answered

one more thing. I know there is a role by name "SQLAgentReaderRole", i can assign but it is a combination of (All of the SQLAgentUserRole rights) + The ability to review multiserver jobs, their configurations and history. So now if i give rights to this role "SQLAgentReaderRole", and if he doesn't own this jobs still can he view the jobs and see the parameters and edit the configuration of the data source, if ssis package is scheduled as a job

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.