Description of the SQL Server Agent jobs in BizTalk Server

Article translations Article translations
Article ID: 919776 - View products that this article applies to.
Expand all | Collapse all
This article lists the Microsoft BizTalk Server SQL Server Agent jobs. This article also describes the SQL Server Agent jobs.

MORE INFORMATION

The following table lists the BizTalk Server SQL Server Agent jobs.
Collapse this tableExpand this table
Job nameDescriptionEnabled by default
Backup BizTalk Server Consists of three steps. Step 1 performs full database backups of the BizTalk Server databases. Step 2 backs up the BizTalk Server database logs. Step 3 specifies for how long the backup history is kept.No
CleanupBTFExpiredEntriesJob_BizTalkMgmtDbDeletes expired BizTalk Framework entries from the BizTalk Management (BizTalkMgmtDb) database.Yes
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.

Note On BizTalk Server 2004, this job is created after you install BizTalk Server 2004 Service Pack 2.
No
MessageBox_DeadProcesses_Cleanup_BizTalkMsgBoxDbDetects 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_BizTalkMsgBoxDbRemoves all messages that are not referenced by any subscribers in the BizTalkMsgBoxDb database tables.

Important This job is also started by the MessageBox_Message_ManageRefCountLog_BizTalkMsgBoxDb job. Therefore, we recommend that you disable this job.

Note On BizTalk Server 2004, this job is enabled by default. Therefore, we recommend that you disable this job.
No
MessageBox_Message_ManageRefCountLog_BizTalkMsgBoxDbManages 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.

Note On BizTalk Server 2004, this job is created after you install BizTalk Server 2004 Service Pack 2.
Yes
MessageBox_Parts_Cleanup_BizTalkMsgBoxDbRemoves 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
MessageBox_UpdateStats_BizTalkMsgBoxDb

Updates the statistics for the BizTalkMsgBoxDb database.

Note This job does not exist on BizTalk Server 2004.
Yes
Monitor BizTalk Server

Scans for any known issues with the BizTalkMgmtDb, BizTalkMsgBoxDb, and BizTalkDTADb databases. This includes orphaned instances.

Note This job is created on BizTalk Server 2010.
Yes
Operations_OperateOnInstances_OnMaster_BizTalkMsgBoxDb Used for multiple BizTalkMsgBoxDb database deployment. It asynchronously performs operational actions. For example, it asynchronously performs bulk terminates on the master BizTalkMsgBoxDb database after those changes are applied to the subordinate BizTalkMsgBoxDb database. 

Note This job does not exist on BizTalk Server 2004. 
Yes
PurgeSubscriptionsJob_BizTalkMsgBoxDbPurges unused subscription predicates from the BizTalkMsgBoxDb database.Yes
Rules_Database_Cleanup_BizTalkRuleEngineDbPurges old audit data from the Rule Engine (BizTalkRuleEngineDb) database every 90 days. This job also purges old history data (deploy/undeploy notifications) from the Rule Engine (BizTalkRuleEngineDb) database every 3 days.

Note This job is created on BizTalk Server 2009.
Yes
TrackedMessages_Copy_BizTalkMsgBoxDbCopies the message bodies of tracked messages from the BizTalkMsgBoxDb database to the Tracking (BizTalkDTADb) database.Yes
TrackingSpool_Cleanup_BizTalkMsgBoxDbPurges inactive tracking spool tables to free database space.

Note This job exists only on BizTalk Server 2004.
No
For a list of the SQL Server Agent jobs and their descriptions on BizTalk Server, visit the following Microsoft Developer Network (MSDN) Web site:
http://msdn2.microsoft.com/en-us/library/aa561960.aspx
Note The BizTalk SQL Server Agent jobs must be owned by a user who has a System Administrator server role on SQL Server.

For more information, click the following article number to view the article in the Microsoft Knowledge Base:
907661 The Tracking_Spool1 or Tracking_Spool2 tables in the BiztalkMsgBoxDb database become very large in BizTalk Server 2004

Properties

Article ID: 919776 - Last Review: February 19, 2011 - Revision: 11.0
APPLIES TO
  • Microsoft BizTalk Server Branch 2010
  • Microsoft BizTalk Server Developer 2010
  • Microsoft BizTalk Server Enterprise 2010
  • Microsoft BizTalk Server Standard 2010
  • Microsoft BizTalk Server 2009 Standard
  • Microsoft BizTalk Server 2009 Enterprise
  • Microsoft BizTalk Server 2009 Developer
  • Microsoft BizTalk Server 2009 Branch
  • Microsoft BizTalk Server 2006 R2 Standard Edition
  • Microsoft BizTalk Server 2006 R2 Enterprise Edition
  • Microsoft BizTalk Server 2006 R2 Developer Edition
  • Microsoft BizTalk Server 2006 R2 Branch Edition
  • Microsoft BizTalk Server 2006 Standard Edition
  • Microsoft BizTalk Server 2006 Enterprise Edition
  • Microsoft BizTalk Server 2006 Developer Edition
  • Microsoft BizTalk Server 2004 Standard Edition
  • Microsoft BizTalk Server 2004 Enterprise Edition
  • Microsoft BizTalk Server 2004 Developer Edition
  • Microsoft BizTalk Server 2004 Partner Edition
Keywords: 
kbbts kbtshoot kbinfo KB919776

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com