Description of the SQL Server Agent jobs in BizTalk Server

Source: Internet
Author: User
Tags biztalk

Job name

Description Enabled 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_BizTalkMgmtDb Deletes expired BizTalk Framework entries from the BizTalk Management (BizTalkMgmtDb) database. Yes
DTA Purge and Archive Automatic 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. No
Note On BizTalk Server 2004, this job is created after you install BizTalk Server 2004 Service Pack 2.
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 BizTalkMsgBoxDb database tables. No
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.
MessageBox_Message_ManageRefCountLog_BizTalkMsgBoxDb Manages the reference count logs for messages and determines when a message is no longer referenced by a subscriber. Yes
This job runs in an infinite loop and deletes the entries from the two individual message reference count logs. This job also CILS 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.
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
MessageBox_UpdateStats_BizTalkMsgBoxDb Updates the statistics for the BizTalkMsgBoxDb database. Yes
Note This job does not exist on BizTalk Server 2004
Operations_OperateOnInstances_OnMaster_BizTalkMsgBoxDb Used for multiple relational database deployment. It asynchronously performs operational actions, such as bulk terminates on the master BizTalkMsgBoxDb database after those changes have been applied to the subordinate BizTalkMsgBoxDb. Yes
Note This job does not exist on BizTalk Server 2004
PurgeSubscriptionsJob_BizTalkMsgBoxDb Purges unused sub‑predicates from the BizTalkMsgBoxDb database. Yes
Rules_Database_Cleanup_BizTalkRuleEngineDb Purges old audit data from the Rule Engine (BizTalkRuleEngineDb) database every 90 days. this job also purges old history data (deploy/undeploy events) from the Rule Engine (BizTalkRuleEngineDb) database every 3 days. Yes
Note This job is created in BizTalk Server 2009.
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
Note This job only exists on the BizTalk Server 2004.
Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.