Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

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

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.

0 votes



3 answers

Permanent link
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.

2 votes

Comments

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?


Permanent link
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

1 vote


Permanent link
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.

0 votes

Comments

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

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

1 vote

Your answer

Register or log in 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 6,130

Question asked: Aug 14 '13, 5:42 a.m.

Question was seen: 7,681 times

Last updated: Aug 21 '13, 5:36 a.m.

Confirmation Cancel Confirm