Phidiax Tech Blog

Adventures in custom software and technology implementation.

BizTalk: Reduce the DTA Tracking Delay When Testing

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
WHILE 1 = 1
   exec bts_CopyTrackedMessagesToDTA @@SERVERNAME, 'BizTalkDTADb'
   WAITFOR TIME '00:00:01'

Privacy Policy  |  Contact  |  Careers

2009-2017 Phidiax, LLC - All Rights Reserved