Content Comparison

...

Step 3: Build Unified Table

Note: This process has been automated and should only be executed manually in cases where the automation has failed to run.

After the ETL process has completed between 6-7am on Tuesdays, execute the following procedure in SQL Server Management Studio before 11am when the Power BI report is refreshed:

USE [cereports]
GO
DECLARE @return_value int
EXEC @return_value = [dbo].[a2vw_mkt_unified_build]
SELECT 'Return Value' = @return_value
GO

...