I'm trying to create a SQL-job step that will be executing a powershell script.
In the Job Step Properties page:
Under Type I choose "Powershell".
Under Run as I have: "SQL Server Agent Service Account".
I then click the "Open" button and navigate to the location of the powershell script (local on the server).
I get this error when I pick the script file and click OK:
Access to the path '...\script.ps1' is denied. (mscorlib)
The SQL Agent account is local admin on the server, so there should be no access issues.
When I RDP to the server using that account, I can navigate to the script location without any problems.
Anyone seen this before? It's not making any sense...
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]