joob.vatcharm
SSC Veteran
Points: 269
More actions
June 25, 2013 at 12:37 am
#276643
I am created a job for run .dts and after job is completed or failed I want to send mail to another person . How can I do.
!! I'am sorry for my English language . I'am Thai. I live in Bangkok
Thank you very much
Andrew G
SSChampion
Points: 12809
June 25, 2013 at 12:46 am
#1626994
Make sure your SQL agent is setup to use SQL Mail. http://msdn.microsoft.com/en-US/library/ms177408%28v=sql.90%29.aspx
Create a SQL Agent Operator, http://msdn.microsoft.com/en-us/library/ms175962%28v=sql.90%29.aspx
Then in the job where you want the email to send, select properties, Notification tab, tick Email and select the operator you created, then select "When the job completes"
michal.lisinski
SSCertifiable
Points: 6933
June 25, 2013 at 12:59 am
#1626997
Hi
Another option, create "Send mail task" in package.
Regards
Mike
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply