BizTalk Server Tutorials and Solutions

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\BTSQLJobsActivityLogs.txt