Description of SQL Jobs used by Biztalk Server

Published on : Aug 23, 2006

Category : BizTalk Server

Saravana

Author

MessageBox_DeadProcesses_Cleanup_BizTalkMsgBoxDb Detects when a BizTalk host instance (BTSNTSvc.exe) has stopped responding. The job then releases the work from the host instance so a different host instance can finish the tasks. MessageBox_Message_Cleanup_BizTalkMsgBoxDb Removes all messages that are not referenced by any subscribers in the BizTalk MessageBox (BizTalkMsgBoxDb) database tables. MessageBox_Parts_Cleanup_BizTalkMsgBoxDb Removes all message parts that are no longer referenced by a message in the BizTalkMsgBoxDb database tables. All messages are composed of one or more message parts that contain the message data. PurgeSubscriptionsJob_BizTalkMsgBoxDb Purges unused subscription predicates from the BizTalkMsgBoxDb database. TrackedMessages_Copy_BizTalkMsgBoxDb Copies the message bodies of tracked messages from the BizTalkMsgBoxDb database to the Tracking (BizTalkDTADb) database. TrackingSpool_Cleanup_BizTalkMsgBoxDb Purges inactive tracking spool tables to free database space.