Remove SQL Server agent jobs
1. Click Start, point to All Programs, click Microsoft SQL Server 2008 R2, and then click SQL Server Management Studio.
2. Click Connect.
3. In Object Explorer, expand SQL Server Agent, and then expand Jobs.
4. Remove the following jobs:
Backup BizTalk Server (BizTalkMgmtDb)
CleanupBTFExpiredEntriesJob_BizTalkMgmtDb
DTA Purge and Archive (BizTalkDTADb)
Monitor BizTalk Server (BizTalkMgmtDb)
MessageBox_DeadProcesses_Cleanup_BizTalkMsgBoxDb
MessageBox_Message_Cleanup_BizTalkMsgBoxDb
MessageBox_Message_ManageRefCountLog_BizTalkMsgBoxDb
MessageBox_Parts_Cleanup_BizTalkMsgBoxDb
MessageBox_UpdateStats_BizTalkMsgBoxDb
Operations_OperateOnInstances_OnMaster_BizTalkMsgBoxDb
PurgeSubscriptionsJob_BizTalkMsgBoxDb
Rules_Database_Cleanup_BizTalkRuleEngineDb
TrackedMessages_Copy_BizTalkMsgBoxDb
Note
If you deployed BAM, you may also need to remove the job named bam_<Cube Name>_<View Name>.
|