Need to Get an Mail Notification from ETL Job

John Daniel · Post by **John Daniel** » Mon Mar 28, 2011 8:24 am

Hi All,

Here My ETL Design is somthing like this.

Source_Tbl, Limit_Tbl, Transformer ----frm Transforer to Seq_file

Source_Tble ----------------------- I will get the Source,
Limit_Tbl ---- have Min_Limit, and Max_Limit for the Source

I want to get an email these details : Source_Count, Min_Limit and Max_Limit Details as Email Body !!

Pls advise me on this

Thanks,

John

ray.wurlod · Post by **ray.wurlod** » Mon Mar 28, 2011 11:20 am

Create a routine that invokes DSSendMail().

John Daniel · Post by **John Daniel** » Tue Mar 29, 2011 1:32 am

Would you please help me to create a routine ............

Pls send me the code for creating routine....to invoke DSSendMail()

Looking for your kind help in this

Thanks,

John

ray.wurlod · Post by **ray.wurlod** » Tue Mar 29, 2011 1:58 am

There's a few examples to be found if you Search DSXchange.

ray.wurlod · Post by **ray.wurlod** » Tue Mar 29, 2011 1:59 am

There's also a couple of examples (e.g. DSSendMailTester) supplied with the product.

chulett · Post by **chulett** » Tue Mar 29, 2011 6:52 am

John Daniel wrote:... as Email Body !!

Just as an FYI, that alone forces you down the routine path. Without it, you could leverage the Email Notification stage in a Sequence job.

John Daniel · Post by **John Daniel** » Tue Mar 29, 2011 7:43 am

Thanks for your inputs !!

It would be better if you provide the code for routine !!

How can I get these 3 columns (Source_count, Min_limit and Max_Limit) data into a mail notifications.

Please advise

Thanks,

John

chulett · Post by **chulett** » Tue Mar 29, 2011 7:51 am

No, it would be a much better learning experience if you manage this on your own... with some guidance, of course.

First order of business would be to capture or store the information you need to send, say like a flat file or the USERSTATUS area of a job. Have you done that?

John Daniel · Post by **John Daniel** » Thu Mar 31, 2011 9:16 am

chulett wrote:No, it would be a much better learning experience if you manage this on your own... with some guidance, of course.

First order of business would be to capture or store the information you need to send, say like a flat file or the USERSTATUS area of a job. Have you done that?

I have done this part 'stored the three valuse in a sequential file'.

After wht should I do ?? Pls guide me in this

Thanks,

John

chulett · Post by **chulett** » Thu Mar 31, 2011 9:22 am

Look at the source code for the DSSendMailTester routine, you'll need to copy and tweak it to fit your purposes. Depending on how you populated it, the data in the flat file could be retrieved using 'cat' at the O/S level or a job could read it. You'll need to combine that with whatever other text you need and send it to your new routine as the email body.

Or save yourself a lot of work - use the Email Notification stage in a Sequence job and simply attach the file.

DSXchange