It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×6,107
×1,235

question asked: Aug 14 '13, 5:42 a.m.
question was seen: 7,357 times
last updated: Aug 21 '13, 5:36 a.m.

Related questions

Can ETL Job result be send to an email (email notification)?

0
Rustan Allen Lajara (1●1●3●3) | asked Aug 14 '13, 5:42 a.m.
Hi,

Is there a way to create an auto email notification sending the details of the result of an ETL job run to an email address? The result should contain details similar to the run history.


Thanks.

3 answers

Most liked answers ↑|Newest answers|Oldest answers

2
permanent link
Piotr Aniola (3.7k●1●17●38) | answered Aug 14 '13, 6:12 a.m.
It is possible as of version 4.0.3.
Please see https://jazz.net/jazz/web/projects/Jazz%20Foundation#action=com.ibm.team.workitem.viewWorkItem&id=205011 for details.
Comments
Jackie Albert commented Aug 14 '13, 8:59 a.m.

Based on what this workitem says, this seems to be true only if you run the data collection jobs from the CLM server itself.  What about if you run the ETL via Rational Insight?
1
permanent link
Francesco Chiossi (5.7k●1●11●19) | answered Aug 14 '13, 9:21 a.m.
Hello,

regarding Insight, starting with version 1.1.1 the statistics on the ETL executions are available on the report server; see Configuring ETL statistics dashboards

An option that can be investigated would be to use IBM Cognos Event Studio (included with Insight) to create an email notification based on conditions from the ETL statistics.

Best Regards
Francesco
0
permanent link
Rustan Allen Lajara (1●1●3●3) | answered Aug 20 '13, 10:11 p.m.
Hi,

Thanks for the information you have posted. However, when we try to access CCM/JTS admin pages but I could not see any options to set the email as indicated on Defect 80830.

We are using Rational Insight 1.1.1 and could not find this entry in the admin page of the CCM application.

Thanks.
Comments
Piotr Aniola commented Aug 21 '13, 4:27 a.m.

Can you please let me know which version of CCM are you using?

1
Francesco Chiossi commented Aug 21 '13, 5:36 a.m.

A clarification, the email notification from CLM only works if you are using the CLM data collection jobs (Java ETL).
With Insight you are supposed to turn off the CLM data collection jobs and run the Data Manager ETL instead.

See Turning off the data collection jobs

Your answer

Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.