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