Files
2025-05-20 09:16:54 -04:00

12 lines
922 B
INI

[global]
mailhost = smtprelay.lmig.com
sender = Qlik_Admin@LibertyMutual.com
receivers = HTTP_509@LibertyMutual.com, PMEDW_Prod_Support@LibertyMutual.com, QLIK_ADMIN@LibertyMutual.com
#receivers = Wendell.Jones@LibertyMutual.com
minutes = 180
query = SELECT T.EXT_NAME, T.REP_HOST, T.REP_NAME, T.SOURCE_DTM FROM EDW_GOLDENGATE_LATENCY_TABLE T inner join (SELECT REP_NAME, MAX(SOURCE_DTM) AS MAX_SOURCE_DTM FROM EDW_GOLDENGATE_LATENCY_TABLE GROUP BY REP_NAME) A on t.REP_NAME = a.REP_NAME and t.SOURCE_DTM = a.MAX_SOURCE_DTM ORDER BY REP_NAME
[sf_targets]
#0=DEV,PL_DEV_QLIK_PM_EDW_TRANS_D,TU5uSHE2WVA=,libertymutual_grm_us_edw.us-east-1,PL_DEV_QLIK_LOAD_WH,PL_DEV,PM_EDW_META_D
2=QA,PL_QA_QLIK_PM_EDW_TRANS_D,T01JN3RDYko=,libertymutual_grm_us_edw.us-east-1,PL_QA_QLIK_LOAD_WH,PL_QA,PM_EDW_META_D
3=PROD,PL_PROD_QLIK_PM_EDW_TRANS_D,bUR4MjV5Ulk=,libertymutual_grm_us_edw.us-east-1,PL_PROD_QLIK_LOAD_WH,PL_PROD,PM_EDW_META_D