I wan't to monitor Data Collection Job in JTS, RTC and RQM
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.
Comments
Raj Kapoor
Sep 07 '12, 6:19 a.m.Please provide any solution.