- Newest
- Most votes
- Most comments
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."
"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
Relevant content
- Accepted Answerasked 4 years ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 8 months ago
- AWS OFFICIALUpdated 2 years ago