He works with customers to provide guidance and technical assistance about various database and analytical projects, helping them improving the value of their solutions when using AWS. Wasim Shaikh is a Database Consultant with AWS Professional Services. If you have any questions or feedback about this blog post, feel free to use the comments area here. In that scenario, just create an extra step in your job. You can repeat the same type of solution if you need to send out email alerts for SQL Server job status. This completes the solution to send Database Mail from RDS for SQL Server with the help of an EC2 instance and linked server connection. The procedure is present on the EC2 SQL Server, and run via the linked server.ĮXEC = 'This email is from = 'This email is from RDS' Now run the sp_send_dbmail stored procedure on the Amazon RDS for SQL Server, as shown below. Step 3: Call a remote sp_send_dbmail stored procedure that is hosted on your EC2 instance from the Amazon RDS via linked server Please refer the post for the details and set up a linked server. My colleague Richard Waymire has written a very helpful blog post describing the process to setup a linked server between RDS for SQL Server and an EC2 instance with SQL Server. Step 2: Setup a linked server between Amazon RDS for SQL Server and your EC2 instance If you want to use multiple RDS instances, repeat steps 7-14, to create more public profiles in conjunction with their instance-linked servers.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |