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...
Behind creating this blog to provide very useful BizTalk concepts and most important that how to resolve BizTalk Errors. In this blog I am glad to share my past and vast experience that relate to BizTalk Server as well as their supporting topics like ESB, BAM, BRE, HAT, PAL etc.. Sometime you feel away-some when your problem has resolved with the helps of my blog then please share your comment. This is my personal blog and never related to my Employer.