We are running DataStage 3.1.1r3 on an NT Server. (Yes, we will be
upgrading.)
We would like to be able to issue an email via SMTP from DataStage when a job aborts. Were locked into SMTP due to the configuration we have, here.
Has anyone done this?
Did you need to install any special software on the server?
How is it done?
Thanks!
Sincerely,
Brad Vincent
Data Warehousing with a "health"-y spin
Compuware
c/o The Detroit Medical Center
(313) 966-2176
Sending SMTP email from DataStage
Brad,
All you need is a command line mail client. I think some have been mentioned here in the past. You should be able to find one that you can download from the Internet. There is no installation involved, they are generally just a single executable file.
Typically, you would write the body of your mail message (unless it is trivially small) to a work file. You might want to create other files as attachments as well. Then run the mail command (Im sure youve done NT commands before) supplying parameters to identify your SMTP server, addressees, file containing the body etc.
You might want to consider storing you email addresses in data somewhere (or at least as a parameter to the job). Further, if you create an address list on your mail server and use this address list in your job then you have even more flexibility.
To take the concept a step further, there are internet based SMS service providers that can generate an SMS message from an email message. We use this to send SMS messages to support staff if important jobs fail in our overnight processing.
David Barham
Information Technology Consultant
InformAtect Pty Ltd
Brisbane, Australia
e-mail: david@barham.hm
-----Original Message-----
From: Vincent, Brad [mailto:BVincent@dmc.org]
Sent: Friday, 25 May 2001 1:47 AM
To: DataStage Mailing List
Subject: Sending SMTP email from DataStage
We are running DataStage 3.1.1r3 on an NT Server. (Yes, we will be
upgrading.)
We would like to be able to issue an email via SMTP from DataStage when a job aborts. Were locked into SMTP due to the configuration we have, here.
Has anyone done this?
Did you need to install any special software on the server?
How is it done?
Thanks!
Sincerely,
Brad Vincent
Data Warehousing with a "health"-y spin
Compuware
c/o The Detroit Medical Center
(313) 966-2176
All you need is a command line mail client. I think some have been mentioned here in the past. You should be able to find one that you can download from the Internet. There is no installation involved, they are generally just a single executable file.
Typically, you would write the body of your mail message (unless it is trivially small) to a work file. You might want to create other files as attachments as well. Then run the mail command (Im sure youve done NT commands before) supplying parameters to identify your SMTP server, addressees, file containing the body etc.
You might want to consider storing you email addresses in data somewhere (or at least as a parameter to the job). Further, if you create an address list on your mail server and use this address list in your job then you have even more flexibility.
To take the concept a step further, there are internet based SMS service providers that can generate an SMS message from an email message. We use this to send SMS messages to support staff if important jobs fail in our overnight processing.
David Barham
Information Technology Consultant
InformAtect Pty Ltd
Brisbane, Australia
e-mail: david@barham.hm
-----Original Message-----
From: Vincent, Brad [mailto:BVincent@dmc.org]
Sent: Friday, 25 May 2001 1:47 AM
To: DataStage Mailing List
Subject: Sending SMTP email from DataStage
We are running DataStage 3.1.1r3 on an NT Server. (Yes, we will be
upgrading.)
We would like to be able to issue an email via SMTP from DataStage when a job aborts. Were locked into SMTP due to the configuration we have, here.
Has anyone done this?
Did you need to install any special software on the server?
How is it done?
Thanks!
Sincerely,
Brad Vincent
Data Warehousing with a "health"-y spin
Compuware
c/o The Detroit Medical Center
(313) 966-2176
Great suggestions, so far. Thanks.
What were looking at is to send via SMTP a specific email which will route through our paging system in order to page the off-hours support person automatically when a job aborts. Ive sent your suggestions to our Tech Group. Well see what happens.
Thanks, again!
Brad Vincent
Data Warehousing with a "health"-y spin
Compuware
c/o The Detroit Medical Center
(313) 966-2176
What were looking at is to send via SMTP a specific email which will route through our paging system in order to page the off-hours support person automatically when a job aborts. Ive sent your suggestions to our Tech Group. Well see what happens.
Thanks, again!
Brad Vincent
Data Warehousing with a "health"-y spin
Compuware
c/o The Detroit Medical Center
(313) 966-2176
Hi Rob,
We successfully tested from my desktop the BLAT utility. Now we have to get it on our server and then have DataStage call it, along with specifics, when our jobs abort. What we will do is issue messages to the Off-hours Support Alpha Pager. The text will be such that it will let the support person know which job aborted.
When I have "the boys" install Outlook (thats what we use, here) on our NT Server that DataStage runs on, will they need to configure it with an actual email address? Is that how you do it at your company? Or do you just have it installed without being configured, and then use someone elses email address for "from" so that bounces or errors have somewhere to go?
Thanks!
Brad
We successfully tested from my desktop the BLAT utility. Now we have to get it on our server and then have DataStage call it, along with specifics, when our jobs abort. What we will do is issue messages to the Off-hours Support Alpha Pager. The text will be such that it will let the support person know which job aborted.
When I have "the boys" install Outlook (thats what we use, here) on our NT Server that DataStage runs on, will they need to configure it with an actual email address? Is that how you do it at your company? Or do you just have it installed without being configured, and then use someone elses email address for "from" so that bounces or errors have somewhere to go?
Thanks!
Brad
Brad,
I assume that BLAT is similar to the mail utility we use. That is, it talks to an SMTP server. If this is the case, you wont need Outlook on your DataStage server at all.
If you are using Outlook, does this mean that you are using Exchange for your mail server? If so, here are some thoughts...
We needed to be able to send messages to addresses outside our organisation (eg for SMS messages). Due to the security on our exchange server, we had to create email addresses on our exchange server with the external SMTP address. Our mail utility sends to a distribution list which we can alter at will to include the external addresses.
You mention the from address. What we did is create a distribution list on our exchange server and use the address of that distribution list as the from address for our DataStage generated mail. Again, this gives us the flexibility to direct responses to the messages we send, where we like. What you do with these all depends on where your messages go. In our case, they go out to an SMS service provider which sends an acknowledgement to the return address, so we need to direct these acknowledgements somewhere appropriate.
I hope this gives you something to think about.
-----Original Message-----
From: Vincent, Brad [SMTP:BVincent@dmc.org]
Sent: Wednesday, May 30, 2001 11:18 PM
To: DataStage Mailing List
Cc: RDaddona@medspan.com
Subject: RE: Sending SMTP email from DataStage
Hi Rob,
We successfully tested from my desktop the BLAT utility. Now we have to get it on our server and then have DataStage call it, along with specifics, when our jobs abort. What we will do is issue messages to the Off-hours Support Alpha Pager. The text will be such that it will let the support person know which job aborted.
When I have "the boys" install Outlook (thats what we use, here) on our NT Server that DataStage runs on, will they need to configure it with an actual email address? Is that how you do it at your company? Or do you just have it installed without being configured, and then use someone elses email address for "from" so that bounces or errors have somewhere to go?
Thanks!
Brad
*************************************************************************
This e-mail and any files transmitted with it may be confidential and are intended solely for the use of the individual or entity to whom they are addressed. If you have received this e-mail in
error, please notify the sender by return e-mail, and delete this e-mail from your in-box. Do not copy it to anybody else
*************************************************************************
I assume that BLAT is similar to the mail utility we use. That is, it talks to an SMTP server. If this is the case, you wont need Outlook on your DataStage server at all.
If you are using Outlook, does this mean that you are using Exchange for your mail server? If so, here are some thoughts...
We needed to be able to send messages to addresses outside our organisation (eg for SMS messages). Due to the security on our exchange server, we had to create email addresses on our exchange server with the external SMTP address. Our mail utility sends to a distribution list which we can alter at will to include the external addresses.
You mention the from address. What we did is create a distribution list on our exchange server and use the address of that distribution list as the from address for our DataStage generated mail. Again, this gives us the flexibility to direct responses to the messages we send, where we like. What you do with these all depends on where your messages go. In our case, they go out to an SMS service provider which sends an acknowledgement to the return address, so we need to direct these acknowledgements somewhere appropriate.
I hope this gives you something to think about.
-----Original Message-----
From: Vincent, Brad [SMTP:BVincent@dmc.org]
Sent: Wednesday, May 30, 2001 11:18 PM
To: DataStage Mailing List
Cc: RDaddona@medspan.com
Subject: RE: Sending SMTP email from DataStage
Hi Rob,
We successfully tested from my desktop the BLAT utility. Now we have to get it on our server and then have DataStage call it, along with specifics, when our jobs abort. What we will do is issue messages to the Off-hours Support Alpha Pager. The text will be such that it will let the support person know which job aborted.
When I have "the boys" install Outlook (thats what we use, here) on our NT Server that DataStage runs on, will they need to configure it with an actual email address? Is that how you do it at your company? Or do you just have it installed without being configured, and then use someone elses email address for "from" so that bounces or errors have somewhere to go?
Thanks!
Brad
*************************************************************************
This e-mail and any files transmitted with it may be confidential and are intended solely for the use of the individual or entity to whom they are addressed. If you have received this e-mail in
error, please notify the sender by return e-mail, and delete this e-mail from your in-box. Do not copy it to anybody else
*************************************************************************