Phidiax Tech Blog

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.

use BizTalkMsgBoxDb
go
WHILE 1 = 1
BEGIN
   exec bts_CopyTrackedMessagesToDTA @@SERVERNAME, 'BizTalkDTADb'
   WAITFOR TIME '00:00:01'
END