Make SqlServer Module Available in SQL Agent - by Aaron Nelson

Status : 


Sign in
to vote
ID 3015502 Comments
Status Active Workarounds
Type Suggestion Repros 0
Opened 8/5/2016 6:06:42 AM
Access Restriction Public


Make the SqlServer Module available in SQL Agent Job Steps as a Type of "SQL PowerShell".  
The community would like to see this happen immediately or at the very latest, by SP1 of SQL Server 2016.
Sign in to post a comment.
Posted by wsmelton on 6/14/2017 at 12:40 PM
I would add that it also not put you in the context of the SQL Server provider (SQLSERVER:\) by default. This is why you generally can't use the step type from the beginning. If you are going to force that then rename the step type to "PowerShell Provider". I would prefer to be within the PowerShell.exe host.
Posted by Chrissy LeMaire on 5/26/2017 at 4:34 AM
Yes, desperately!
Posted by js_0505ps on 5/26/2017 at 4:33 AM