BizTalk Server Tutorials and Solutions Skip to main content

Posts

Showing posts from 2022

Enable or Disable BizTalk SQL Jobs using Powershel Script

Welcome back to another PowerShell script nice article!! This script would be helpful to enable or disable BizTalk SQL jobs in a click only, easy to run either lower or production environment. At the bottom of the post, you can see all the file name. Considering Points:  > Login user should be part for BizTalk Administrator Group >  $instancename  - Use your environment instance name >  $sqljoblist  - Update path as per BTSqlJobs.txt file >  $logpath  - Provide path directory > In case of more than one BizTalk SQL instances, copy scripts to other instance and update BT Sql job(s) in 'BTSQLJobs' file Enable BizTalk SQL Jobs: (File- psEnableBTSQLJobs.ps1) param ( [ string ] $instancename = 'LAPTOP-CF8KHTV1' , [ string ] $sqljoblist = 'D:\Dell\Biztalk\BizTalkLive\BizTalkPowerShellService\StarStopBTSQLJobs\BTSqlJobs.txt' , [ string ] $logpath = 'D:\Dell\Biztalk\BizTalkLive\BizTalkPowerShellService\StarStopBTSQLJobs\BTSQLJobsActiv...