A test 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.
Example: Run as: SQL Server Agent Service Account powershell.exe -file \Server02\test2\Test.ps1
The agent account has been given access to
This test file currently does something very basic: displays a string
When it runs, it does not show an error message, because it just hangs. Do you have any ideas about what is happening, or which security settings are missing?
Aucun commentaire:
Enregistrer un commentaire