Calling remote powershell script through SQL server agent

• SQL_Surfer

  SSCrazy Eights

  Points: 8320

  More actions

  January 23, 2021 at 8:36 pm

  #3836682

  I have a powershell script in remote server.  When I go to remote server and execute the script, it works as indented.

  When I schedule it to run through SQL server agent, it just says succeeded but code really doesn't do anything.

  Any help would be appreciated.

  I've attached sql server agent image, how the job is setup.

   

  Am I missing something?

   

   

   

  Attachments:

  You must be logged in to view attached files.

• Phil Parkin

  SSC Guru

  Points: 247155

  More actions

  January 24, 2021 at 11:49 am

  #3836814

  Are you hoping that the script will execute on the remote server? Or is that just the place where you store PoSh scripts?

  ---

• SQL_Surfer

  SSCrazy Eights

  Points: 8320

  More actions

  January 24, 2021 at 2:09 pm

  #3836846

  Yeah, hoping that the script will execute on the remote server.

• Phil Parkin

  SSC Guru

  Points: 247155

  More actions

  January 24, 2021 at 2:25 pm

  #3836847

  SQL_Surfer wrote:

  Yeah, hoping that the script will execute on the remote server.

  Unfortunately, it won't. It will instead try to execute locally.

  But all is not lost, you can use Powershell Remoting to execute PoSh commands on remote servers. Take a look here to get started:

  https://docs.microsoft.com/en-us/powershell/scripting/learn/remoting/running-remote-commands?view=powershell-7.1

  ---