How to change sender of SSIS job failure emails?
0
The DBA who set up our SSIS jobs is no longer with the company. However, when an SSIS job fails, it sends an email with the old DBA as the sender.
Where is this configured and how do I change it?
ssis
asked Nov 14 '18 at 0:49
Mark NugentMark Nugent
941211
add a comment |
0
The DBA who set up our SSIS jobs is no longer with the company. However, when an SSIS job fails, it sends an email with the old DBA as the sender.
Where is this configured and how do I change it?
ssis
asked Nov 14 '18 at 0:49
Mark NugentMark Nugent
941211
2
"It" sends an email. What is "it"? It could be your scheduling tool (SQL Agent) has an on failure job step associated with it and it's using something like sp_send_dbmail. The SSIS package itself might have an OnError event or path defined that then sends mail using a stored procedure or it connects to a mail system like Exchange. There could be a Script Task and they send email via that - the possibilities are too many to cover here.
– billinkc
Nov 14 '18 at 2:03
If packages are run via SQL Agent, script that and see if there is a reference to sp_send_dbmail. If not, you'll need to dig through the SSIS package. Screenshots can help people get a high level appreciation for what the package does but the devil with SSIS is that every object on the canvas might have a "hidden" event associated to it.
– billinkc
Nov 14 '18 at 2:04
@billinkc : I guess he's referring to the following: right clickjob->properties->Notifications->E-Mail. OP Please correct if I'm not following.
– Prabhat G
Nov 14 '18 at 13:48
@billinkc that is correct. On the Notifications page of the agent job, email is configured to be sent to me when the job fails. But nowhere does it say who is the sender of the email. Would it be the email address of the AD account that owns the job?
– Mark Nugent
Nov 14 '18 at 15:58
I believe you're after the database mail configuration. In SSMS look for "Management", expand and look for "Database Mail", right click and choose "Configure Database Mail". That opens the wizard. Since this is an existing setup, choose the "Manage Database Mail accounts and Profiles", next and then "View, Change..." . That should get you going in the right direction.
– Tim Mylott
Nov 14 '18 at 19:35
add a comment |
0
0
0
The DBA who set up our SSIS jobs is no longer with the company. However, when an SSIS job fails, it sends an email with the old DBA as the sender.
Where is this configured and how do I change it?
ssis
asked Nov 14 '18 at 0:49
Mark NugentMark Nugent
941211
The DBA who set up our SSIS jobs is no longer with the company. However, when an SSIS job fails, it sends an email with the old DBA as the sender.
Where is this configured and how do I change it?
ssis
ssis
asked Nov 14 '18 at 0:49
Mark NugentMark Nugent
941211
asked Nov 14 '18 at 0:49
Mark NugentMark Nugent
941211
asked Nov 14 '18 at 0:49
Mark NugentMark Nugent
941211
asked Nov 14 '18 at 0:49
Mark NugentMark Nugent
941211
asked Nov 14 '18 at 0:49
Mark NugentMark Nugent
941211
941211
2
"It" sends an email. What is "it"? It could be your scheduling tool (SQL Agent) has an on failure job step associated with it and it's using something like sp_send_dbmail. The SSIS package itself might have an OnError event or path defined that then sends mail using a stored procedure or it connects to a mail system like Exchange. There could be a Script Task and they send email via that - the possibilities are too many to cover here.
– billinkc
Nov 14 '18 at 2:03
If packages are run via SQL Agent, script that and see if there is a reference to sp_send_dbmail. If not, you'll need to dig through the SSIS package. Screenshots can help people get a high level appreciation for what the package does but the devil with SSIS is that every object on the canvas might have a "hidden" event associated to it.
– billinkc
Nov 14 '18 at 2:04
@billinkc : I guess he's referring to the following: right clickjob->properties->Notifications->E-Mail. OP Please correct if I'm not following.
– Prabhat G
Nov 14 '18 at 13:48
@billinkc that is correct. On the Notifications page of the agent job, email is configured to be sent to me when the job fails. But nowhere does it say who is the sender of the email. Would it be the email address of the AD account that owns the job?
– Mark Nugent
Nov 14 '18 at 15:58
I believe you're after the database mail configuration. In SSMS look for "Management", expand and look for "Database Mail", right click and choose "Configure Database Mail". That opens the wizard. Since this is an existing setup, choose the "Manage Database Mail accounts and Profiles", next and then "View, Change..." . That should get you going in the right direction.
– Tim Mylott
Nov 14 '18 at 19:35
add a comment |
2
"It" sends an email. What is "it"? It could be your scheduling tool (SQL Agent) has an on failure job step associated with it and it's using something like sp_send_dbmail. The SSIS package itself might have an OnError event or path defined that then sends mail using a stored procedure or it connects to a mail system like Exchange. There could be a Script Task and they send email via that - the possibilities are too many to cover here.
– billinkc
Nov 14 '18 at 2:03
If packages are run via SQL Agent, script that and see if there is a reference to sp_send_dbmail. If not, you'll need to dig through the SSIS package. Screenshots can help people get a high level appreciation for what the package does but the devil with SSIS is that every object on the canvas might have a "hidden" event associated to it.
– billinkc
Nov 14 '18 at 2:04
@billinkc : I guess he's referring to the following: right clickjob->properties->Notifications->E-Mail. OP Please correct if I'm not following.
– Prabhat G
Nov 14 '18 at 13:48
@billinkc that is correct. On the Notifications page of the agent job, email is configured to be sent to me when the job fails. But nowhere does it say who is the sender of the email. Would it be the email address of the AD account that owns the job?
– Mark Nugent
Nov 14 '18 at 15:58
I believe you're after the database mail configuration. In SSMS look for "Management", expand and look for "Database Mail", right click and choose "Configure Database Mail". That opens the wizard. Since this is an existing setup, choose the "Manage Database Mail accounts and Profiles", next and then "View, Change..." . That should get you going in the right direction.
– Tim Mylott
Nov 14 '18 at 19:35
2
2
"It" sends an email. What is "it"? It could be your scheduling tool (SQL Agent) has an on failure job step associated with it and it's using something like sp_send_dbmail. The SSIS package itself might have an OnError event or path defined that then sends mail using a stored procedure or it connects to a mail system like Exchange. There could be a Script Task and they send email via that - the possibilities are too many to cover here.
– billinkc
Nov 14 '18 at 2:03
"It" sends an email. What is "it"? It could be your scheduling tool (SQL Agent) has an on failure job step associated with it and it's using something like sp_send_dbmail. The SSIS package itself might have an OnError event or path defined that then sends mail using a stored procedure or it connects to a mail system like Exchange. There could be a Script Task and they send email via that - the possibilities are too many to cover here.
– billinkc
Nov 14 '18 at 2:03
If packages are run via SQL Agent, script that and see if there is a reference to sp_send_dbmail. If not, you'll need to dig through the SSIS package. Screenshots can help people get a high level appreciation for what the package does but the devil with SSIS is that every object on the canvas might have a "hidden" event associated to it.
– billinkc
Nov 14 '18 at 2:04
If packages are run via SQL Agent, script that and see if there is a reference to sp_send_dbmail. If not, you'll need to dig through the SSIS package. Screenshots can help people get a high level appreciation for what the package does but the devil with SSIS is that every object on the canvas might have a "hidden" event associated to it.
– billinkc
Nov 14 '18 at 2:04
@billinkc : I guess he's referring to the following: right click
job -> properties -> Notifications -> E-Mail. OP Please correct if I'm not following.– Prabhat G
Nov 14 '18 at 13:48
@billinkc : I guess he's referring to the following: right click
job -> properties -> Notifications -> E-Mail. OP Please correct if I'm not following.– Prabhat G
Nov 14 '18 at 13:48
@billinkc that is correct. On the Notifications page of the agent job, email is configured to be sent to me when the job fails. But nowhere does it say who is the sender of the email. Would it be the email address of the AD account that owns the job?
– Mark Nugent
Nov 14 '18 at 15:58
@billinkc that is correct. On the Notifications page of the agent job, email is configured to be sent to me when the job fails. But nowhere does it say who is the sender of the email. Would it be the email address of the AD account that owns the job?
– Mark Nugent
Nov 14 '18 at 15:58
I believe you're after the database mail configuration. In SSMS look for "Management", expand and look for "Database Mail", right click and choose "Configure Database Mail". That opens the wizard. Since this is an existing setup, choose the "Manage Database Mail accounts and Profiles", next and then "View, Change..." . That should get you going in the right direction.
– Tim Mylott
Nov 14 '18 at 19:35
I believe you're after the database mail configuration. In SSMS look for "Management", expand and look for "Database Mail", right click and choose "Configure Database Mail". That opens the wizard. Since this is an existing setup, choose the "Manage Database Mail accounts and Profiles", next and then "View, Change..." . That should get you going in the right direction.
– Tim Mylott
Nov 14 '18 at 19:35
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
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: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
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
});
}
});
draft saved
draft discarded
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%2fstackoverflow.com%2fquestions%2f53291611%2fhow-to-change-sender-of-ssis-job-failure-emails%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- 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.
draft saved
draft discarded
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%2fstackoverflow.com%2fquestions%2f53291611%2fhow-to-change-sender-of-ssis-job-failure-emails%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
2
"It" sends an email. What is "it"? It could be your scheduling tool (SQL Agent) has an on failure job step associated with it and it's using something like sp_send_dbmail. The SSIS package itself might have an OnError event or path defined that then sends mail using a stored procedure or it connects to a mail system like Exchange. There could be a Script Task and they send email via that - the possibilities are too many to cover here.
– billinkc
Nov 14 '18 at 2:03
If packages are run via SQL Agent, script that and see if there is a reference to sp_send_dbmail. If not, you'll need to dig through the SSIS package. Screenshots can help people get a high level appreciation for what the package does but the devil with SSIS is that every object on the canvas might have a "hidden" event associated to it.
– billinkc
Nov 14 '18 at 2:04
@billinkc : I guess he's referring to the following: right click
job->properties->Notifications->E-Mail. OP Please correct if I'm not following.– Prabhat G
Nov 14 '18 at 13:48
@billinkc that is correct. On the Notifications page of the agent job, email is configured to be sent to me when the job fails. But nowhere does it say who is the sender of the email. Would it be the email address of the AD account that owns the job?
– Mark Nugent
Nov 14 '18 at 15:58
I believe you're after the database mail configuration. In SSMS look for "Management", expand and look for "Database Mail", right click and choose "Configure Database Mail". That opens the wizard. Since this is an existing setup, choose the "Manage Database Mail accounts and Profiles", next and then "View, Change..." . That should get you going in the right direction.
– Tim Mylott
Nov 14 '18 at 19:35