Create alert for SFG and add changes in all weekly Load SP's and monitor job.

Analysis :

1)did analsis and Checked all th SPS to add the io alert for sfg and provided to mohan , below are the sp .

SP :

[dbo].[SP05_102_E2E_APIDP_LoadAlert_Horizon_Weekly]

[SP03_013_SR_refresh_MD_to_History_Weekly_APIDP]

Table :

web.sr_apidp_alert

web.SR_ALERT_APIDP_HISTORY

2)Developed on table and sp for sotpvt column usage where the ETD columns where required.

[dbo].[SPROC_99_99_53_imp_LAP_ETD_Keyfigures_SFG]

imp_LAP_ETD_Keyfigures_SFG