| title | description | author | ms.author | ms.reviewer | ms.topic |
|---|---|---|---|---|---|
Using NOSQLPS for SQL Server Agent with PowerShell |
Message to explain to use the sqlserver powershell cmdlet instead of the sqlps cmdlet with SQL Server Agent |
markingmyname |
maghan |
drskwier |
include |
Starting with SQL Server 2019, you can disable SQLPS. On the first line of a job step of the type PowerShell you can add #NOSQLPS, which stops the SQL Agent from auto-loading the SQLPS module. Now your SQL Agent Job runs the version of PowerShell installed on the machine, and then you can use any other PowerShell module you like.
To use the SqlServer module in your SQL Agent Job step, you can place this code on the first two lines of your script.
#NOSQLPS
Import-Module -Name SqlServer