Need to Get an Mail Notification from ETL Job
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 42
- Joined: Mon Oct 15, 2007 10:35 pm
- Location: Charlotte
- Contact:
Need to Get an Mail Notification from ETL Job
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
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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 42
- Joined: Mon Oct 15, 2007 10:35 pm
- Location: Charlotte
- Contact:
Need to Get an Mail Notification from ETL Job
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
Pls send me the code for creating routine....to invoke DSSendMail()
Looking for your kind help in this
Thanks,
John
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
There's a few examples to be found if you Search DSXchange.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: Need to Get an Mail Notification from ETL Job
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 wrote:... as Email Body !!
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 42
- Joined: Mon Oct 15, 2007 10:35 pm
- Location: Charlotte
- Contact:
Re: Need to Get an Mail Notification from ETL Job
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
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
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?
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?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 42
- Joined: Mon Oct 15, 2007 10:35 pm
- Location: Charlotte
- Contact:
I have done this part 'stored the three valuse in a sequential file'.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?
After wht should I do ?? Pls guide me in this
Thanks,
John
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.
Or save yourself a lot of work - use the Email Notification stage in a Sequence job and simply attach the file.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers