TFS Notifications debugging

[Reflection.Assembly]::Load("Microsoft.TeamFoundation.Client, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"); $collectionBaseUrl = "http://YOURTFSSERVER:8080/tfs/YOURCOLLECTION/"; $tfs = [Microsoft.TeamFoundation.Client.TeamFoundationServerFactory]::GetServer($collectionBaseUrl); $collectionHive = $tfs.GetService([Microsoft.TeamFoundation.Framework.Client.ITeamFoundationRegistry]); $collectionHive.SetValue("/Service/Integration/Settings/NotificationJobLogLevel", "2"); Note: Zero to turn off debug mode SELECT TOP 10 DATEADD(hour, -6, StartTime) as StartTimeCDT, Result, ResultMessage FROM [Tfs_Configuration].[dbo].[tbl_JobHistory] WHERE JobId = 'A4804DCF-4BB6-4109-B61C-E59C2E8A9FF7' --AND Result <> 0 ORDER BY StartTime DESC