Agent productivity report being killed by Instrumentation

Created by David O'Neil, Modified on Wed, 30 Jul at 5:48 AM by David O'Neil

Recompile the 4 sprocs in the report

EXEC sp_recompile 'sp_AgentProductivity';

exec sp_AgentProductivity '20240408','20240414','*','HAL001003'

EXEC sp_recompile 'p_AgentProdByAgtByVendor';

exec p_AgentProdByAgtByVendor '20240408','20240414','*','HAL001001'

EXEC sp_recompile 'p_AgentProdSummary';

exec p_AgentProdByAgtByVendor '20240408','20240414','*','HAL001001'

EXEC sp_recompile 'sp_AgentProductivity_h';

exec sp_AgentProductivity_h '20240408','20240414','*','HAL001001',@RunBy=1