regarding subroutine DSSENDMAIL

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
Saama
Premium Member
Premium Member
Posts: 83
Joined: Wed Nov 22, 2006 6:42 pm
Location: Pune
Contact:

regarding subroutine DSSENDMAIL

Post by Saama »

hi,
i want to send email when the job is success. iam using after jobsubroutine
DSSENDMAIL.
i have also tried to use jobactivity and notification activity inorder to send email.
whats the difference in approach, will the both give the same result.
in the notification activity
how to know my SMTP MAIL SERVER NAME
my operating system is windows.
suppose if i use DSSENDMAIL as after subroutine- what should i give value.
plz help me in analyzing.

cheers;
saama
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

Did you try not giving anything. Its the same server as your outlook server. Get more details from your system admin.
Well both the approaches will achieve what you require. You have more flexibility in a sequence job by using notification activity. You can attach the job report etc.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Saama
Premium Member
Premium Member
Posts: 83
Joined: Wed Nov 22, 2006 6:42 pm
Location: Pune
Contact:

Post by Saama »

Hi Gurus,
As gurus suggestion iam going for a sequence and linking it to notification activity.
my design is job activity1---->jobactivity2----->notificationactivity
parameters declared in jobactivities.
triggers tab-> conditional ok for both jobs.
in notification activity-
SMTP MAIL SERVER NAME: MAIL.SAAMA.COM
SENDERS EMAIL ID: KKK@SAMMA.COM
RECEIVER EMAIL ID: SSS@YAHOO.COM
i have given email subject too, it runs fine, but i didn't receive any notification mail to my yahoomail id. please help me, why am i not getting any mail yahoo, is there something iam missing.

plz help me.
cheers;
saama
narasimha
Charter Member
Charter Member
Posts: 1236
Joined: Fri Oct 22, 2004 8:59 am
Location: Staten Island, NY

Post by narasimha »

What does the log message in your director say about the job.
Does it say Sent message to 'SSS@YAHOO.COM' ?

Just curious, Do you get a mail when you send it to you@your_company.com
Give that a try.
Narasimha Kade

Finding answers is simple, all you need to do is come up with the correct questions.
Saama
Premium Member
Premium Member
Posts: 83
Joined: Wed Nov 22, 2006 6:42 pm
Location: Pune
Contact:

Post by Saama »

hi gurus,
when i see, iam getting error message.
ERROR WHILE EXECUTING COMMAND.
C:\ASCENTIAL\DATASTAGE\PROJECT NAME
SMTP MAIL NETWORK ERROR 10053.
TRY TO ADJUST DSSEND MAIL_TEMPLATE.TXT.
cant i mail to yahoo or gmail.when i want to send to yahoo or gmail account, what will be name of SMTP MAIL SERVER.
plz help me.

cheers;
saama
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

Were you able to send the mail to your local network mail group?
You may need to set up each smtp for each mail group. eg: smtp.google.com,smtp.mail.yahoo.com
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
narasimha
Charter Member
Charter Member
Posts: 1236
Joined: Fri Oct 22, 2004 8:59 am
Location: Staten Island, NY

Post by narasimha »

Saama wrote:cant i mail to yahoo or gmail.when i want to send to yahoo or gmail account, what will be name of SMTP MAIL SERVER.
You can.
You don't need to change the SMTP Mail server name to send your mail to Yahoo or Google.
Were you successful in sending your mail to your company id?
Narasimha Kade

Finding answers is simple, all you need to do is come up with the correct questions.
Saama
Premium Member
Premium Member
Posts: 83
Joined: Wed Nov 22, 2006 6:42 pm
Location: Pune
Contact:

Post by Saama »

Hi gurus,
i cant send to my companys mail id, it simply says SMTP SERVER CONNECTION FAILURE.so i want to send to yahoos or gmails.what would i write the name of SMTP SERVER for google or for yahoo.

SMTP SERVER NAME:
SENDER EMAIL ID- SSS@GMAIL.COM
RECEIVER EMAIL ID-YYY@YAHOO.COM
i want to make sure that its working fine, in this case what would be the name of SMTP SERVER.

plz help me .
cheers;
saama
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Chances are that your company has blocked access to these "mail" email addresses. Check with the mail administrator.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply