I need to develop a query to identify Processes(Jobs) whose completion times are increasing over time and approaching their end time. The logic created is to identify Processes(Jobs) in danger of breaches in SQL.
Example: if the job starts at 2pm and will take 3 hours of duration the completion time of this job is 5pm. However, the schedule agreed time for it to completes is 7. So if we observe the that job starting a 5pm it complete at 8pm. This will be a breach.