Introduction

In SQL Server Agent Execution of each supported job step is handled by a subsystem. Except for TSQL steps, each subsystem is handled by an external .dll file that is loaded into SQL Agent’s process at startup. Each subsystem takes information about the job step to execute and interprets it according to its own definition.

Problem

We need to enable more threads for SQL Server Agent jobs that are running PowerShell

Solution

https://github.com/steverezhener/DBA/blob/master/Procedures/bestpractices.usp_adjust_server_sub_system_default_max_worker_thread.sql

Example

Based on https://blog.sqlterritory.com/2018/09/25/sql-server-agent-job-waiting-for-a-worker-thread/