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.
1
stars
0
forks
source link
Change TOTAL_STEP_COUNT in [dbo].[JOB_STEP_AVERAGE_DURATION] to EXECUTION COUNT #23
Decide if this is worth having.