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.
SQL Server RDS migration to EC2 SQL ServerAccepted Answerasked 6 months ago
Announcement: Amazon RDS for SQL Server ending support for Microsoft SQL Server 2012asked 8 months 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
DMS to migrate SQL Server from RDS to EC2asked 3 years ago
RDS sql-server snapshot export to S3Accepted Answerasked 5 months ago
Is transactional replication supported in RDS SQL Server or RDS Custom for SQL Server?asked 2 months ago
Amazon RDS Custom SQL-Server: Agent not runningAccepted Answerasked 4 months ago
RDS MS SQL server ODBC Linked server connection issuesasked 8 days ago
SQL Server on RDS Issue With Linked ServerAccepted AnswerEXPERTasked 2 years ago