Enhancement in Sql Script using BIP

Job ID: 37355668

Budget: ₹600 – ₹1,500 INR

I need an experienced SQL coder to help me with an enhancement to a SQL script. The specified enhancement should include alerting on long running jobs, and I will provide detailed requirements. This is very urgent and needs to be completed within 24 hours.
In existing ESS Dashboard, In the long Running Jobs we have standard 30 Mins time limit. We need a parameter where where we can customize the long running Jobs as per customer requirement (Trigger email once the ESS Job reaches max runtime). To calculate Average time for all the ESS Jobs and display the Average time column in the ESS Dashboard.