Page 1 of 1

Interesting E-mail notification problem

Posted: Wed Jul 27, 2005 9:09 am
by I_Server_Whale
Hi All,

I have created two jobs. I created a job sequence to sequence these two jobs. I run this job sequence through a DOS batch file and capture the exit (Status) code to a text file. Now, I want send e-mail notification of the job sequence, may be a %fullreport%.

For doing this, I tried using the 'Notification Activity' stage. The 'Notification Activity' stage asks for SMTP Server. But we are not using SMTP. We are using INET protocol. Can I still use this stage? If not, do I have any other options to send e-mail notification of the job report?

Is DSSendMail function of any use for my case? Also, can I use DSSendMail function in a batch file? Any tiny weeny help in this direction would be of great magnitude.

Thanks a lot,
Naveen.

Posted: Wed Jul 27, 2005 9:46 am
by I_Server_Whale
Hi All,

Any help on this??? :cry:

Naveen.

Posted: Wed Jul 27, 2005 9:51 am
by pnchowdary
Hi NaveenD,

Try giving the IP address of your mail server in the SMTP field.

Posted: Wed Jul 27, 2005 9:52 am
by ArndW
Naveen,

the mail call is just an interlude to the command line "mail" on unix. If your mail system uses the same command line syntax then the protocol actually used to encode/decode and transmit the mails is not important. If you have a different command then you will need to "fake" this call by creating your own mail.sh program that get the parameter values from DataStage and passes them on in the correct format to your mailer.