Install Powershell for SQL Server.

Run the Powershell from SQL Server Job:

 

 

If you are getting the below error – need to install the SQLServer and SQLPS modules.

 

 

 

 

 

 

After that you can invoke the Powershell from SQLServer Agent