I have developed an async batch system using the Agent Jobs in SQL Server 2017. It is working really well. I have one issue with setting up the operations staff to run this. We get the following error
Only a sysadmin can specify '@output_file_name' parameter for a jobstep
The user has been set up on the msdb with the following Database role membership; SQLAgentOperatorRole SQLAgentReaderRole SQLAgentUserRole
What it looks like happening is that the user can create (and delete) agents, but when we try and run the code then error above comes up which seems very odd.
For now I have temporarily granted sysadmin to get him working, but quite keen to revoke those right if we can resolve this.
Any help would be appreciated