This stored procedure is no longer required after installing Biztalk 2004 SP2. You should remove this job and configure the newly created one called DTA Purge and Archive, see here for more information see http://technet.microsoft.com/en-us/library/aa558715.aspx
Monthly Archive: January 2009
Permanent link to this article: http://www.tsls.co.uk/index.php/2009/01/15/after-apply-biztalk-2004-sp2-exec-dtasp_prunetrackingdatabase-fails/
Jan
15
BTS 2004 SP2 TDDS_FailedTrackingData Error
After applying Biztalk SP2 you may receive the following error Event Type: Error Event Source: BAM EventBus Service Event Category: None Event ID: 6 Date: 13/01/2009 Time: 17:12:55 User: N/A Computer: JDW54 Description: Execute event error. Error(s) occurred while executing events, see TDDS_FailedTrackingData table for more details. SQLServer: SQL1, Database: BizTalkDTADb You return the data …
Permanent link to this article: http://www.tsls.co.uk/index.php/2009/01/15/bts-2004-sp2-tdds_failedtrackingdata-error/
Jan
13
Remove stuck messages and purge messages in BizTalk 2004
note: this will remove everything and should be tested in a UAT environment first. If need to purge your messages in BizTalk 2004 that can’t be removed from HAT run through the following: — Stop Receive Locations — Stop BizTalk Service (all Nodes) — Make Sure HAT is cleared of all messages (apart from the …
Permanent link to this article: http://www.tsls.co.uk/index.php/2009/01/13/remove-stuck-messages-in-biztalk-2004/