Database Mail on Amazon RDS / SQL ServerSQL Server Database Mail failing to send emails with error Sender...
Why do neural networks need so many examples to perform?
Boss asked me to sign a resignation paper without a date on it along with my new contract
Is .NET Framework 3.5 still needed with a SQL Server 2017 installation to utilize Database Mail?
How can find the 2D Voronoi cell area distribution?
Taking an academic pseudonym?
Why did Luke use his left hand to shoot?
Why is it that Bernie Sanders is always called a "socialist"?
How does resistance convert voltage to current?
Co-worker sabotaging/undoing my work. (Software Development)
Writing dialogues for characters whose first language is not English
Why does alert(0.-5) print -5?
How can I give a Ranger advantage on a check due to Favored Enemy without spoiling the story for the player?
Why didn't Tom Riddle take the presence of Fawkes and the Sorting Hat as more of a threat?
Is it possible to rotate the Isolines on a Surface Using `MeshFunction`?
Other than edits for international editions, did Harry Potter and the Philosopher's Stone receive errata?
Is there any danger of my neighbor having my wife's signature?
Modern Algebraic Geometry and Analytic Number Theory
How to fly a direct entry holding pattern when approaching from an awkward angle?
How to deal with an underperforming subordinate?
Was there a pre-determined arrangement for the division of Germany in case it surrendered before any Soviet forces entered its territory?
What is an efficient way to digitize a family photo collection?
Why is "rm -r" unable to delete this folder?
Minimum Viable Product for RTS game?
Why are mages sometimes played bot instead of traditional ADCs?
Database Mail on Amazon RDS / SQL Server
SQL Server Database Mail failing to send emails with error Sender address rejected: Access deniedSQL Server Database Mail - Why can't I run an execute against xp_sysmail_activate?Database Mail sending functionality not working on local systemUse SQL Server Database Mail with Amazon SNSSQL Server Database Mail Log is flooded with errors (20-30 per second) when mail server goes downIntermittent errors sending email from SQL Server Database MailSQL database mail sending test mail not query resultCan send test database mail but job emails failingIs there any way to write to CloudWatch from an AWS RDS SQL Server Instance?How to send Unicode symbols using SQL Server Database Mail?
Since Database Mail is not supported on Amazon RDS with SQL Server, can anyone offer any suggestions on how to send e-mail notifications for failed SQL Server jobs in Amazon RDS?
Thanks in advance for any suggestions or workarounds.
sql-server amazon-rds database-mail
asked Aug 25 '18 at 20:28
equipe9equipe9
423
add a comment |
Since Database Mail is not supported on Amazon RDS with SQL Server, can anyone offer any suggestions on how to send e-mail notifications for failed SQL Server jobs in Amazon RDS?
Thanks in advance for any suggestions or workarounds.
sql-server amazon-rds database-mail
asked Aug 25 '18 at 20:28
equipe9equipe9
423
add a comment |
Since Database Mail is not supported on Amazon RDS with SQL Server, can anyone offer any suggestions on how to send e-mail notifications for failed SQL Server jobs in Amazon RDS?
Thanks in advance for any suggestions or workarounds.
sql-server amazon-rds database-mail
asked Aug 25 '18 at 20:28
equipe9equipe9
423
Since Database Mail is not supported on Amazon RDS with SQL Server, can anyone offer any suggestions on how to send e-mail notifications for failed SQL Server jobs in Amazon RDS?
Thanks in advance for any suggestions or workarounds.
sql-server amazon-rds database-mail
sql-server amazon-rds database-mail
asked Aug 25 '18 at 20:28
equipe9equipe9
423
asked Aug 25 '18 at 20:28
equipe9equipe9
423
asked Aug 25 '18 at 20:28
equipe9equipe9
423
asked Aug 25 '18 at 20:28
equipe9equipe9
423
asked Aug 25 '18 at 20:28
equipe9equipe9
423
423
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
AWS has posted a detailed blog post based on the way that UnderArmor solves this limitation. It involves a linked SQL Server that you run in EC2 and that EC2 instance is configured to SES to relay the messages through.
AWS RDS Database Mail
edited Feb 15 at 20:51
LowlyDBA
7,07252542
answered Feb 15 at 20:30
AaronAaron
1,4321419
add a comment |
You have 2 choices:
Have an EC2 server with SQL Server installed to relay all email notification through Database Mail. Set up as a linked server and call a stored procedure to send the email via SQL Server's Database Mail.
Use the Cloud Alert or other 3rd party software for notification of failed jobs.
edited 5 mins ago
hot2use
8,35752055
answered Feb 15 at 17:45
SwoozieSwoozie
12
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f215876%2fdatabase-mail-on-amazon-rds-sql-server%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
AWS has posted a detailed blog post based on the way that UnderArmor solves this limitation. It involves a linked SQL Server that you run in EC2 and that EC2 instance is configured to SES to relay the messages through.
AWS RDS Database Mail
edited Feb 15 at 20:51
LowlyDBA
7,07252542
answered Feb 15 at 20:30
AaronAaron
1,4321419
add a comment |
AWS has posted a detailed blog post based on the way that UnderArmor solves this limitation. It involves a linked SQL Server that you run in EC2 and that EC2 instance is configured to SES to relay the messages through.
AWS RDS Database Mail
edited Feb 15 at 20:51
LowlyDBA
7,07252542
answered Feb 15 at 20:30
AaronAaron
1,4321419
add a comment |
AWS has posted a detailed blog post based on the way that UnderArmor solves this limitation. It involves a linked SQL Server that you run in EC2 and that EC2 instance is configured to SES to relay the messages through.
AWS RDS Database Mail
edited Feb 15 at 20:51
LowlyDBA
7,07252542
answered Feb 15 at 20:30
AaronAaron
1,4321419
AWS has posted a detailed blog post based on the way that UnderArmor solves this limitation. It involves a linked SQL Server that you run in EC2 and that EC2 instance is configured to SES to relay the messages through.
AWS RDS Database Mail
edited Feb 15 at 20:51
LowlyDBA
7,07252542
answered Feb 15 at 20:30
AaronAaron
1,4321419
edited Feb 15 at 20:51
LowlyDBA
7,07252542
edited Feb 15 at 20:51
LowlyDBA
7,07252542
edited Feb 15 at 20:51
LowlyDBA
7,07252542
7,07252542
answered Feb 15 at 20:30
AaronAaron
1,4321419
answered Feb 15 at 20:30
AaronAaron
1,4321419
answered Feb 15 at 20:30
AaronAaron
1,4321419
1,4321419
add a comment |
add a comment |
You have 2 choices:
Have an EC2 server with SQL Server installed to relay all email notification through Database Mail. Set up as a linked server and call a stored procedure to send the email via SQL Server's Database Mail.
Use the Cloud Alert or other 3rd party software for notification of failed jobs.
edited 5 mins ago
hot2use
8,35752055
answered Feb 15 at 17:45
SwoozieSwoozie
12
add a comment |
You have 2 choices:
Have an EC2 server with SQL Server installed to relay all email notification through Database Mail. Set up as a linked server and call a stored procedure to send the email via SQL Server's Database Mail.
Use the Cloud Alert or other 3rd party software for notification of failed jobs.
edited 5 mins ago
hot2use
8,35752055
answered Feb 15 at 17:45
SwoozieSwoozie
12
add a comment |
You have 2 choices:
Have an EC2 server with SQL Server installed to relay all email notification through Database Mail. Set up as a linked server and call a stored procedure to send the email via SQL Server's Database Mail.
Use the Cloud Alert or other 3rd party software for notification of failed jobs.
edited 5 mins ago
hot2use
8,35752055
answered Feb 15 at 17:45
SwoozieSwoozie
12
You have 2 choices:
Have an EC2 server with SQL Server installed to relay all email notification through Database Mail. Set up as a linked server and call a stored procedure to send the email via SQL Server's Database Mail.
Use the Cloud Alert or other 3rd party software for notification of failed jobs.
edited 5 mins ago
hot2use
8,35752055
answered Feb 15 at 17:45
SwoozieSwoozie
12
edited 5 mins ago
hot2use
8,35752055
edited 5 mins ago
hot2use
8,35752055
edited 5 mins ago
hot2use
8,35752055
8,35752055
answered Feb 15 at 17:45
SwoozieSwoozie
12
answered Feb 15 at 17:45
SwoozieSwoozie
12
answered Feb 15 at 17:45
SwoozieSwoozie
12
12
add a comment |
add a comment |
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f215876%2fdatabase-mail-on-amazon-rds-sql-server%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
