SQL Server job hangs when it executes a
Powershell script. It does work using my login and a
Powershell window, but not using the
Agent account and a job. The
SQL Agent user has read/write/execute permissions to the directory with the powershell script.
Run as: SQL Server Agent Service Account powershell.exe -file \\Server02\test2\Test.ps1
The agent account has been given access also.
This test file currently does something very basic: displays a string.
When it runs, it does not show an error message, because it just does not respond. Do you have any idea about what is happening, or which security settings are missing?