Hi Team,
I have requirement, I need to start job in QMC based on one SQL Query like below
SELECT *
FROM DBT_META_CTCT_PRD.TB_PROCESS
WHERE load_cd = 'FWL'
AND process_name = 'FWL' and stat_cd=2
QUALIFY ROW_NUMBER()
OVER (ORDER BY process_start_dtm DESC) =1
The job needs to be trigger whenever stat_cd=2 daily basis. If Stat_cd=1 or Stat_cd=3 it should ignore
Please help me how can we do this?
Thanks,
Siva
