How to grant user access to view / edit Advanced option in the SQL Job running in the SQL Agent?
User has ability to view the job. Under Job Properties -> Steps -> Advanced Option.
View options are disabled. How to grant permission for the user to view the results in the Advanced Option.
You can't give them permission to access that View button without granting them access to also make changes to the job.
What you can do is grant access to execute msdb..sp_help_jobsteplog which will return the recorded log for the jobstep.
EXEC dbo.sp_help_jobsteplog @job_name = N'JobName';
Alternatively, you could grant permission to query msdb..sysjobstepslogs directly which is where the data is stored anyway.
SELECT [log]
FROM msdb..sysjobstepslogs JSL
JOIN msdb..sysjobsteps JS
ON JS.step_uid = JSL.step_uid
JOIN msdb..sysjobs J
ON J.job_id = JS.job_id
WHERE J.name = N'JobName'
Based on the offical Microsoft documentation:
For security reasons, only the job owner or a member of the sysadmin role can change the definition of the job. Only members of the sysadmin fixed server role can assign job ownership to other users, and they can run any job, regardless of the job owner.
You can read more in the following link:
