How to send EMAIL from Data Stage
Posted: Wed Apr 26, 2006 7:40 am
Hi
i m using notification activity to send email from data stage .
while doing this
i m giving in notification TAB
SMTP server name as our server name, and all the other values listed there.
But i m not able to get the output . my job is getting aborted and the warning message is :-
EMAIL..JobControl (DSSendMail): Error when executing command: C:\Ascential\DataStage\Projects\myproject\sendmail_EMAIL.bat
*** Output from command was: ***
SMTPMail Looking up server...
SMTPMail Opening connection to <my server name>...
SMTPMail Unknown failure!
SMTPMail Error in trying to connect
SMTPMail Network error 10060
Please check any paths in the following command file are correct, and if necessary adjust the 'dssendmail_template.txt' file in the project directory.
Contents of command file:
C:\Ascential\DataStage\Engine\bin\dssmtpmail.exe -file sendmail_EMAIL_file.tmp
can u please help me out in this. do i need to do any other settings.
i m using notification activity to send email from data stage .
while doing this
i m giving in notification TAB
SMTP server name as our server name, and all the other values listed there.
But i m not able to get the output . my job is getting aborted and the warning message is :-
EMAIL..JobControl (DSSendMail): Error when executing command: C:\Ascential\DataStage\Projects\myproject\sendmail_EMAIL.bat
*** Output from command was: ***
SMTPMail Looking up server...
SMTPMail Opening connection to <my server name>...
SMTPMail Unknown failure!
SMTPMail Error in trying to connect
SMTPMail Network error 10060
Please check any paths in the following command file are correct, and if necessary adjust the 'dssendmail_template.txt' file in the project directory.
Contents of command file:
C:\Ascential\DataStage\Engine\bin\dssmtpmail.exe -file sendmail_EMAIL_file.tmp
can u please help me out in this. do i need to do any other settings.