As silly as it may seem, when delivering BizTalk solutions, I get impatient waiting for the DTA Copy Tracked Data job to run at the top of the minute.
I mean, how hard is it to get that data into the tracking database...? I want it now.
So, I wrote a simple little SQL Script that I run while I'm testing to do that for me.
Run this on the SQL Server the Message Box is on.
WHILE 1 = 1
exec bts_CopyTrackedMessagesToDTA @@SERVERNAME, 'BizTalkDTADb'
WAITFOR TIME '00:00:01'