Description of the SQL Server Agent jobs in BizTalk Server 2004 (919776)

MORE INFORMATION

The following table lists all BizTalk Server 2004 SQL Server Agent jobs.

Note There will be a new SQL Server Agent job named MessageBox_Message_ManageRefCountLog_BizTalkMsgBoxDb after you install the hotfix that is included in the following article in the Microsoft Knowledge Base: This SQL Server agent job is enabled by default and should remain enabled. This job may also be created if you install other Biztalk 2004 fixes that were released after May 2, 2006. This job supercedes the job named MessageBox_Message_Cleanup_BizTalkMsgBoxDb, which should then be disabled.

Job name	Description	Enabled by default
Backup BizTalk Server	Consists of two steps. Step 1 performs full database backups of the BizTalk Server databases. Step 2 backs up the BizTalk Server database logs.	No
CleanupBTFExpiredEntriesJob_BizTalkMgmtDb	Deletes expired BizTalk Framework entries from the BizTalk Management (BizTalkMgmtDb) database.	Yes
MessageBox_DeadProcesses_Cleanup_BizTalkMsgBoxDb	Detects when a BizTalk Server 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.	Yes
MessageBox_Message_Cleanup_BizTalkMsgBoxDb	Removes all messages that are not referenced by any subscribers in the BizTalk MessageBox (BizTalkMsgBoxDb) database tables. Important This is an unscheduled job that is started by the MessageBox_Message_ManageRefCountLog_BizTalkMsgBoxDb job. Do not manually start this job or enable it.	No
MessageBox_Message_ManageRefCountLog_BizTalkMsgBoxDb	Manages the reference count logs for messages and determines when a message is no longer referenced by a subscriber. This job runs in an infinite loop and deletes the entries from the two individual message reference count logs. This job also calls the MessageBox_Message_Cleanup_BizTalkMsgBoxDb job. Important At first, the MessageBox_Message_ManageRefCountLog_BizTalkMsgBoxDb job status icon displays a status of Success. However, there will be no corresponding success entry in the job history. If one of the jobs in the MessageBox_Message_ManageRefCountLog_BizTalkMsgBoxDb job fails, a failure entry appears in the job history and the status icon displays a status of Failure. The job will always display a status of Failure after the first failure. To verify that the other BizTalk Server SQL Server Agent jobs run correctly, check the status of the other BizTalk Server SQL Server Agent jobs.	Yes
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.	Yes
PurgeSubscriptionsJob_BizTalkMsgBoxDb	Purges unused subscription predicates from the BizTalkMsgBoxDb database.	Yes
TrackedMessages_Copy_BizTalkMsgBoxDb	Copies the message bodies of tracked messages from the BizTalkMsgBoxDb database to the Tracking (BizTalkDTADb) database.	Yes
TrackingSpool_Cleanup_BizTalkMsgBoxDb	Purges inactive tracking spool tables to free database space.	No