Interesting E-mail notification problem

I_Server_Whale · Post by **I_Server_Whale** » Wed Jul 27, 2005 9:09 am

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.

I_Server_Whale · Post by **I_Server_Whale** » Wed Jul 27, 2005 9:46 am

Hi All,

Any help on this???

Naveen.

pnchowdary · Post by **pnchowdary** » Wed Jul 27, 2005 9:51 am

Hi NaveenD,

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

ArndW · Post by **ArndW** » Wed Jul 27, 2005 9:52 am

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.