This project builds a data mart from the SQL Server Agent tables. It implements an increment load design and includes type 2 slowly changing dimension handling for jobs and job steps.
Make it simple. Change the calculation of average job step duration to include every job state that completed successfully. Don't worry about figuring out the jobs where every step completed successfully. Focus on every job step that completes successfully.
Make it simple. Change the calculation of average job step duration to include every job state that completed successfully. Don't worry about figuring out the jobs where every step completed successfully. Focus on every job step that completes successfully.