Hi All ,
I need to run powershell script which is located in other server, lets say server A . In server B , i created the SQL job ..
What is the query that I need to put in Command area so I can run it as ( ABC\xxx ) and execute the script using that account ?
type : powershell
script location : \\serverA\D$\folderA\script.ps1
default : running as sql server agent account
i tried : runas /user:ABC\xxx "\\serverA\D$\folderA\script.ps1”
the outcome of sql job is asking the password which is not what i expect …
i expect to see Hello world as it is written in my simple script
please kindly help