E-mail the messgae of job completion in SSIS

Question

Post reply

E-mail the messgae of job completion in SSIS

sachinrshetty

SSCrazy

Points: 2062
More actions
April 8, 2010 at 12:17 am

#140160

I have automated the process of ssis package execution. But i want to send an email to the operator soon after the job scheduled gets completed.
How to send the e-mail.
Please reply if you know the answer
Sachin

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 246985 More actions · Answer 1

Have you tried using the Send Mail task?

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

sachinrshetty SSCrazy Points: 2062 More actions · Answer 2

Hi Phil I tried to use that but I got struck in configuring smtp server.

Is there any other method other than using send mail task or how to proceed in this itself

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 3

If you are using a job in SQL Agent, you can use the Notifications tab in the properties window of the job. Click E-mail, choose an operator (this must be added by your DBA) and then choose When the job succeeds.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

sandy_1006 SSC Eights! Points: 953 More actions · Answer 4

Hi,You can configure smtp mail by asking your system administration.By the way are you using Microsoft Mail like outlook etc or Lotus (IBM).If it is Microsoft mail than u can check incoming mail server IP address or ask your system admin ,thanks hope it helps

sachinrshetty SSCrazy Points: 2062 More actions · Answer 5

Hi i tried this now, but execution of package was successful but In history log its showing message "Failed to Notify Sachin.R via email"

How to solve this issue. Please help me

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 6

Are you added as one of the operators?

If you are, are all your credentials set up correctly in SQL Server?

This is more of a DBA issue than a SSIS issue, so I'm not really familiar with this problem.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

sachinrshetty SSCrazy Points: 2062 More actions · Answer 7

k Thank you very much da-zero for responding to my problem

sachinrshetty SSCrazy Points: 2062 More actions · Answer 8

I have got it done. I added send mail task and configured smtp with help of admin and it was successful.