- Compiled by BizTalkers for BizTalkers
The purpose of this blog is to compile all the solutions I found over the period of time.
One of the new features introduced in BizTalk 2010 is the Monitor BizTalk Server SQL Agent job. This job was added to the product to provide an out-of-the-box way to identify database integrity issues that we previously had to use MBV or manual SQL scripts to identify. If this job identifies a database integrity issue, the job itself will fail with a custom error message that describes the problem that was identified. A database admin or a monitoring tool like SCOM can take a look at SQL Agent to identify when a problem has occurred.
See the BizTalk Server Monitoring section at http://msdn.microsoft.com/en-us/library/aa577454 (BTS.70).aspx for more information about this job.
Terminator provides the easiest way to resolve most of these issues once they have occurred. Use the steps below to resolve issues identified by the Monitor BizTalk Server Job.
Manual Task Selection
DELETE Orphaned Instance Subscriptions
View Count of Orphaned Instance Subscriptions