BizTalk relies heavily on SQL server to persist the information about the environment. Therefore administrators face the need to access the SQL server frequently to view the 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 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 is used to take backup of the database logs. To perform operations on SQL Server Jobs:
- Log into the BizTalk360 application
- Click the Operations icon
- Click the expand button against ‘Infrastructure Settings’ tab and select ‘SQL Server Instances’ link
- Select the required Instance name and the details regarding the Instance will be displayed
- Click on ‘SQL Server Jobs’ tab
- Inline operations can be performed directly from the Grid View. You can perform the required operation in 3 different ways -
- Selecting the SQL Job (check box) and clicking on the Operation buttons (Enable/Disable) at the top of the grid
- Selecting the SQL Job (check box). When you do this, you will notice an inline operation showing up right next to the check box with the possible operations that you can perform on the SQL Job.
- Hovering over the record in the Current State column - When you hover the mouse over the Current State column, you will notice the possible operations that can be performed.
User Access Policy
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.