search

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

UPDATE SQL AGENT Dimensions #12

Closed agent86ray closed 3 years ago

agent86ray commented 3 years ago

CREATE SEQUENCE dbo.JOB_KEY

CREATE table [staging].[sysjobs_UPDATE] to figure out inserts, updates and deletes to sysjobs

CREATE TABLES dbo.sysjobs - add column JOB_KEY INT dbo.sysjobsteps - add column JOB_KEY INT