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
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 [...]
If need to purge your messages in BizTalk 2004 that can’t be removed from HAT run through the following (note this will remove everything) — Stop Receive Locations — Stop BizTalk Service (all Nodes) — Make Sure HAT is cleared of all messages (apart from the stuck messages) — Drop BTS views use biztalkdtadb exec [...]
Sharepoint Alertz BBC News