It's all about the answers!

Ask a question

I wan't to monitor Data Collection Job in JTS, RTC and RQM

Raj Kapoor (2741930) | asked Sep 06 '12, 8:02 a.m.
edited Sep 07 '12, 2:45 p.m. by Robert Rassmann (9923)
 I wan't to monitor data collection job script running in report tab in JTS, RQM, RTC.

It runs at 12:00 in night but which script runs it I don't know, is there any specific path or name of script?
Moreover I am thinking of editing it so that I can get a information on my mail related to its failure.Is it possible, if yes then how?

I will appreciate your help!!

Raj Kapoor commented Sep 07 '12, 6:19 a.m.

Please provide any solution.

Accepted answer

permanent link
Rafik Jaouani (5.0k16) | answered Sep 07 '12, 3:43 p.m.

Hi Raj, are you talking about the out of the box Data Warehouse ETLs.

I really think once the ETLs are properly configured, they should not fail. Our ETLs on have been green for more than a couple years except for a few times where the server gets shutdown in the middel of an ETL.

Currently I am not aware of any easy way to make the ETL send an Email if there is a failure. I guess you could poll the CONFIG.ETL_INFO table for recent failures. The ETL_INFO table is the table that stores the ETL results.

Raj Kapoor selected this answer as the correct answer

Your answer

Register or to post your answer.