Figure 1. BizTalk Server Database Jobs visible under SQL Server Agent Jobs.
Figure 2. Job Properties of Monitor BizTalk Server Job - Steps.
Figure 3. Job Properties of Monitor BizTalk Server Job - Steps.
Figure 4. Monitor BizTalk Server Job History (click to enlarge).
[Problem Code], Issue.nvcProblemDescription
Inconsistancy.nProblemCode = Issue.nProblemCode
Inconsistancy.nCount > 0
Figure 5. Result from executing query on the custom view.
In case issues are detected by the Monitor BizTalk Server Job you will need to take action to resolve them. The BizTalk terminator tool can aid you in resolving any of the issues detected by this job. See the blog post created by One Blog for BizTalk Engineers:
Using BizTalk Terminator to resolve issues identified by BizTalk MsgBoxViewer and the BizTalk 2010 Monitor BizTalk Server Job. The terminator tool can be obtained through the Microsoft Download Center:
Note: When using the terminator tool. Backup BizTalk Databases Stop all host instances and Stop SQL Agent. Read the full description of each task before running it!
Read related topics:
Another important place to find a huge amount of BizTalk related articles is the TechNet Wiki itself. The best entry point is
BizTalk Server Resources on the TechNet Wiki
One more nice article!!!!!!!!
you can also use BizTalk 360 as a way to let your operators see the results from Steef-Jan's query through the BTS360 custom SQL queries.
I explain how here