SQL Server Instances
  • 28 Mar 2023
  • 2 Minutes to read
  • Dark
  • PDF

SQL Server Instances

  • Dark
  • PDF

Article Summary

BizTalk relies heavily on SQL servers to persist information about the environment. Therefore administrators face the need to access SQL Server frequently to view BizTalk-related information. To address this challenge, BizTalk360 displays the basic information from all the configured SQL servers, from a BizTalk perspective, within the user interface. A SQL job is a specified series of operations performed sequentially by an SQL Server Agent. A job can perform a wide range of activities, including running Transact-SQL scripts, command prompt applications, Microsoft ActiveX scripts, Integration Services packages, Analysis Services commands, and queries, or Replication tasks. SQL Jobs like Backup BizTalk Server are used to take a backup of the databases.

SQL Server Instances

To perform operations on SQL Server Jobs:

  • Log in to the BizTalk360 application
  • Click the Administration icon
  • Click the expand button against the Infrastructure Settings tab and select the SQL Server Instances link
  • Select the required Instance name and the details regarding the Instance will be displayed
  • Click on the SQL Server Jobs tab. All the jobs under the selected SQL instance will be listed along with their name, current state, last run status, and description

  • To perform an operation, select the SQL Job (checkbox) and click on the Operation buttons (Enable/Disable) at the top of the grid.
  • Select the Job and click on the eye icon in the row to view the history of the selected job. The history of the job will be listed along with the Run status, Run executed time, duration and description. Users can expand the run to view the step details
  • The succeded and the failed steps are differentiated by the color code 

Grid Filter -To do a better search from the grid columns, filter capability is implemented for the grid columns of SQL Jobs. A user can filter the data from the respective rows according to their needs.

The following types of filters have been implemented in the grid columns of SQL Jobs:

  • Status filter 
  • Text filter

SQL Jobs History

All the SQL jobs executed in the selected SQL instance will be listed under SQL jobs history section along with the job name, current state, execution status, and description. Click on the eye icon to view more details of the Job history, which opens the Job History details blade. The following details will be listed under the Job History blade,

General Details

  • Job Name 
  • Owner Name 
  • Run Status
  •  Category 
  • Created Date Time
  •  Modified Date Time 
  •  Last Executed Date Time 
  •  Description

Step Details 

  • Step Id 
  • Step Name 
  • Last executed time 
  • Run Status 
  • Description

The rich filter component is provided to query the job history based on the status, Datetime and max records.

The SQL Jobs and SQL Job history can be downloaded as excel or pdf for further reference by using the Export option at the top.

User Access Policy Settings for SQL Server Instances

The Super-user can impose security restrictions on normal users from performing operations on the SQL Jobs. This can be set in the User Access Policy under Settings. For users who don’t have the privilege to perform operations on the SQL Jobs, the action buttons will not be visible. 

 BizTalk Databases

This tab shows information about the BizTalk-related databases that are configured under the SQL Server Instances. BizTalk360 will automatically list all the BizTalk databases that are configured in the specific SQL Server Instances.

To view the information of the BizTalk Databases:

  • Navigate to Administration->Manage Infrastructure->SQL Instances 
  • Select the required Instance name and the details regarding the Instance will be displayed
  • Click on the BizTalk Databases tab

Was this article helpful?

What's Next

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