Database Queries
  • Updated on 01 May 2018
  • 1 minute to read
  • Contributors
  • Print
  • Share
  • Dark
    Light

Database Queries

  • Print
  • Share
  • Dark
    Light

Setting up monitoring for Database queries

  • Log in to the BizTalk360 application
  • Click 'Monitoring' in the navigation panel
  • Click the expand button against 'Manage Mapping' tab and select 'BizTalk Environment' link

BizTalk360-Monitoring-SQL-Queries-BizTalk-Environment.png

  • Select the Alarm name (see Creating an alarm) from the drop down for which you would like to associate the alerts

BizTalk360-Monitoring-SQL-Queries-Select-Alarm.png

  • At the tab pages at the top, select Database Query
  • Click New Query button to set up monitoring for the database query
  • Enter the Name for the Alert, add the SQL Instance name, and the SQL Database name

BizTalk360-Monitoring-SQL-Queries-Select-Database-Query.png

  • Click Next to add the Query and Threshold details
  • Enter the SQL query in the space provided
  • Select the Warning and Error Conditions when BizTalk360 must return an alert

BizTalk360-Monitoring-SQL-Queries-Configure-Thresholds.png

  • Click OK to Save the monitoring information

BizTalk360-Monitoring-SQL-Queries-Alert-Created.png

Was this article helpful?