Description of the SQL Server Agent jobs in BizTalk Server
This article lists the SQL Server Agent jobs in Microsoft BizTalk Server.
Original product version: BizTalk Server 2013, 2010, 2009
Original KB number: 919776
List of BizTalk SQL Agent jobs
The following table lists the BizTalk SQL Agent jobs.
|Job name||Description||Enabled by default|
|Backup BizTalk Server||Consists of three steps:
|CleanupBTFExpiredEntriesJob_BizTalkMgmtDb||Deletes expired BizTalk Framework entries from the BizTalk Management (
|DTA Purge and Archive||Automates the archiving of tracked messages and the purging of the BizTalk Tracking database to maintain a healthy system and to keep the tracking data archived for future use. On BizTalk Server 2004, this job is created after you install BizTalk Server 2004 Service Pack 2.||No|
|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
|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_Parts_Cleanup_BizTalkMsgBoxDb||Removes all message parts that are no longer referenced by a message in the
|MessageBox_UpdateStats_BizTalkMsgBoxDb||Updates the statistics for the
|Monitor BizTalk Server||Scans for any known issues with the
|Operations_OperateOnInstances_OnMaster_BizTalkMsgBoxDb||Used for multiple
|PurgeSubscriptionsJob_BizTalkMsgBoxDb||Purges unused subscription predicates from the
|Rules_Database_Cleanup_BizTalkRuleEngineDb||Purges old audit data from the Rule Engine (
|TrackedMessages_Copy_BizTalkMsgBoxDb||Copies the message bodies of tracked messages from the
|TrackingSpool_Cleanup_BizTalkMsgBoxDb||Purges inactive tracking spool tables to free database space. This job exists only on BizTalk Server 2004.||No|
For a list of the SQL Server Agent jobs and their descriptions on BizTalk Server, see Database Structure and Jobs.
The BizTalk SQL Agent jobs must be owned by a user who has a System Administrator server role on SQL Server.