If anyone encounters the same issue, I've changed the SELECT calls to the tables to use instead the available store procedures which any user with the SQLAgentUserRole is allowed to execute.
For example, instead of selecting rows from
dbo.sysjobsteps table, calling the
msdb.dbo.sp_help_jobstep store procedure returns the necessary information.
Linked server connection from on-prem SQL Server to RDS MySQL?asked 2 months ago
SQL Server RDS migration to EC2 SQL ServerAccepted Answerasked 6 months ago
DMS to migrate SQL Server from RDS to EC2asked 3 years ago
AWS RDS SQL Server Agent Tablesasked 2 months ago
Sizing RDS SQL Server for existing SQL Server running on Windows ServerAccepted Answerasked 2 months ago
RDS sql-server snapshot export to S3Accepted Answerasked 5 months ago
Amazon RDS Custom SQL-Server: Agent not runningAccepted Answerasked 4 months ago
SQL Server on RDS Issue With Linked ServerAccepted AnswerEXPERTasked 2 years ago
RDS MS SQL server ODBC Linked server connection issuesasked 11 days ago
Announcement: Amazon RDS for SQL Server ending support for Microsoft SQL Server 2012asked 8 months ago