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’ “

AWS/RDS – Delete Instance

Background For one of the projects we are standing up in AWS, I will like to test out different Instance configuration options. Constraints It has a big database and I did not want to continue eating the cost of standing up various instances.  It is time to stand down of some of the instances.   … Continue reading AWS/RDS – Delete Instance

SQL Server Agent on AWS/RDS

Background There is quite a bit of SQL Server management surface area that is not available when running on AWS/RDS.   Surface Area For instance with SQL Server Agent :- SQL Server Agent Category Add new category API sp_add_category Error Msg 229, Level 14, State 5, Procedure msdb.dbo.sp_add_category The EXECUTE permission was denied on the … Continue reading SQL Server Agent on AWS/RDS