agent86ray SQL-AGENT-JOB-DATA-MART issues

agent86ray / SQL-AGENT-JOB-DATA-MART

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

issues

Newest

Newest Most commented Recently updated Oldest Least commented Least recently updated

Change Average Step Duration

#31 agent86ray opened 3 years ago
0
Add Close ETL History Log stored proc

#30 agent86ray opened 3 years ago
0
Remove columns from JOB_STEP_INSTANCE - MAYBE

#29 agent86ray opened 3 years ago
0
Remove columns from JOB_INSTANCE - MAYBE

#28 agent86ray opened 3 years ago
0
UPDATE ETL_HISTORY_LOG END_DATE

#27 agent86ray opened 3 years ago
0
Add table to specify jobs to exclude

#26 agent86ray closed 3 years ago
0
Get Power BI report ready

#25 agent86ray opened 3 years ago
0
Fix calculation of Execution Count

#24 agent86ray opened 3 years ago
0
Change TOTAL_STEP_COUNT in [dbo].[JOB_STEP_AVERAGE_DURATION] to EXECUTION COUNT

#23 agent86ray opened 3 years ago
0
Refine calculation of remaining job steps

#22 agent86ray opened 3 years ago
0
Exclude SQL AGENT DATA MART jobs from [staging].[vsysjobhistory]

#21 agent86ray opened 3 years ago
0
Check [dbo].[SimulateJobStepDuration] stored procedure

#20 agent86ray opened 3 years ago
0
Get rid of former current rows in JOB_CURRENT

#19 agent86ray opened 3 years ago
0
Add step to HISTORY job to calculate average duration

#18 agent86ray opened 3 years ago
0
BUG: New row added to [dbo].[sysjobs] when date_modified hasn't changed

#17 agent86ray opened 3 years ago
0
Handle early arriving fact in JOB_INSTANCE fact table

#16 agent86ray opened 3 years ago
1
Document the rules for updating the SQL Agent dimensions

#15 agent86ray opened 3 years ago
0
Perform Incremental Load of JobStepInstance table

#14 agent86ray opened 3 years ago
0
Perform Incremental Load of JobInstance table

#13 agent86ray opened 3 years ago
0
UPDATE SQL AGENT Dimensions

#12 agent86ray closed 3 years ago
0
STAGE SQL AGENT Dimensions

#11 agent86ray closed 3 years ago
0
sysjobactivity

#10 agent86ray opened 4 years ago
0
SQL Agent service behavior

#9 agent86ray opened 4 years ago
0
sysjobhistory extract

#8 agent86ray opened 4 years ago
0
Develop incremental extract pattern for sysjobsteps

#7 agent86ray closed 3 years ago
0
Early arriving facts

#6 agent86ray opened 4 years ago
0
Develop General Incremental Extract Pattern

#5 agent86ray opened 4 years ago
0
Develop Incremental Extract Pattern for sysjobs

#4 agent86ray closed 3 years ago
0
Create SSIS master package for fact extract and stage

#3 agent86ray opened 4 years ago
0
Create SSIS master package for dimension extract and stage

#2 agent86ray opened 4 years ago
0
Create ETL Process Fact Table

#1 agent86ray opened 4 years ago
0