Access exe on EC2 from AWS RDS SQL Instance

Hi,

From the Documentation [+] https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.SQLServer.CommonDBATasks.Agent.html

"Running replication jobs and running command-line scripts by using ActiveX, Windows command shell, or Windows PowerShell aren't supported."

[+] https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_SQLServer.html#SQLServer.Concepts.General.FeatureNonSupport

"Extended stored procedures, including xp_cmdshell" --> This is not supported.

RDS Custom on the other hand should allow above limitations. [+] https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/working-with-custom-sqlserver.html

Hello AWS Customer,

I understand that you are migrating from on-premise SQL instance to AWS RDS SQL instance, you would like to know if it is possible to create a SQL job on the AWS instance that will call the exe on EC2. As you may know that RDS SQL Server is a managed service, access to the underlying host is restricted. However as a workaround you may use RDS Custom[1][2].



Wishing you a great day ahead.

References:


[1]Using SQL Server Agent - https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.SQLServer.CommonDBATasks.Agent.html 


[2]Working with RDS Custom for SQL Server - https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/working-with-custom-sqlserver.html