Execute Powershell script on remote server RRS feed

  • Question

  • I have two servers A and B.

    A is the DB server with no front-end access (i can't install or change anything)

    Server A doesn't have powershell but B has. powersshell. I want to execute a powershell script (located on server B), using a SQL Agent job on Server A.

    The powershell script refreshes a powerBI dataset.

    First approach was invoke command but since server A doesn't have powershell, it doesn't work.

    Please advise (if ) how can I achieve this?

    Thanks in advance.

    • Edited by VaibhavM24 Tuesday, October 15, 2019 2:21 PM
    Tuesday, October 15, 2019 1:23 PM

All replies