O'Reilly logo

BizTalk Server 2010 Cookbook by Steef-Jan Wiggers

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Leveraging the BizTalk monitoring job

A new feature in the BizTalk Server 2010 is a new SQL job that enables you to identify any known issues in the Management, Message Box, or DTA databases. This job and other database jobs are created when you configure a BizTalk group. It scans for issues, but does not fix them for you. The job scans for the following issues in the Management, Message Box, and DTA databases:

  • Messages without any references
  • Messages without reference counts
  • Messages with reference counts less than zero
  • Message references without spool rows
  • Message references without instances
  • Instance states without instances
  • Instance subscriptions without corresponding instances
  • Orphaned DTA service instances
  • Orphaned DTA service instance exceptions ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required