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?