This Stored Proc will check all satellite tables (prefix s_)  and see if they have any zero hub keys (prefix h_).

This should not happen if the order of the jobs is correct when building the data vault.

The code makes use of custom Red parameters, in this case we named it email_to_addr_on_updates. Enter the emails you want the procedure to contact after it runs.

 

 

Share This Via: