I wan't to monitor Data Collection Job in JTS, RTC and RQM
Raj Kapoor (27●4●19●30)
| asked Sep 06 '12, 8:02 a.m.
edited Sep 07 '12, 2:45 p.m. by Robert Rassmann (992●3)
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!!
|
Accepted answer
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 jazz.net 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
|
Comments
Please provide any solution.