Overview
  • 01 May 2018
  • 1 Minute to read
  • Dark
    Light
  • PDF

Overview

  • Dark
    Light
  • PDF

Article Summary

When a BizTalk server environment is set up, there are SQL Server jobs that get installed and scheduled automatically to maintain the health of the BizTalk environment. SQL jobs are responsible for variety of purposes in a BizTalk environments such as Moving Tracking Data from BizTalk MessageBox database to the Tracking database, archiving and purging tracking data based on your company policy, purging unused subscriptions, and so on. If the SQL jobs stop processing you will start seeing significant database growth and performance degradation, so monitoring these jobs to be running according the best practices is vital for a healthy BizTalk environment.

BizTalk360 offers a tool for BizTalk Administrators to monitor a BizTalk solution by running database queries, that can be evaluated against a defined threshold and receive alerts when the query does not meet these thresholds. The administrators can set the warning and error condition values in BizTalk360. The database query monitoring requires queries that return a scalar value such as string, integer or Boolean. Once the query is saved, BizTalk360 checks for the query result and alerts the administrator when the value exceeds the threshold range.


Was this article helpful?

What's Next
ESC

Eddy, a super-smart generative AI, opening up ways to have tailored queries and responses