SQL Server Stretch is a technology introduced in SQL Server 2016 that allows to select tables and decide to keep part of the data in Azure Cloud and part of the data on premises.
The idea behind this technology is to keep the "cold data" in the cloud and the "hot data" on the premises
SQL Server Integration Services includes log providers that you can use to implement logging in packages, containers, and tasks. With logging, you can capture run-time information about a package, helping you audit and troubleshoot a package every time it is run.
I have developed a script to review the runtime of Jobs scheduled to run multiple times day on SQL Server 2005.
the script has been developed on SQL server 2005 and gives the ability to find out from all active jobs the precentage of running time divided to job interval in the last 24 hours.