AWS/RDS – SQL Server – Error – “The EXECUTE permission was denied on the object ‘agent_datetime’, database ‘msdb’, schema ‘dbo’ “

Background Here is an error I have been wanting to talk about for a while here. Code msdb.dbo.agent_datetime Outline The agent.date_time function accepts two integer values, date and time. And, returns the corresponding datetime value. SQL Output Output - AWS Here is the result when we issue command against an ASW/RDS MS SQL Server Instance. … Continue reading AWS/RDS – SQL Server – Error – “The EXECUTE permission was denied on the object ‘agent_datetime’, database ‘msdb’, schema ‘dbo’ “