April 3, 2017 at 11:37 am
Hey all,
I can run my PS script just fine via the command line. Yet, when I setup an Agent job for a PowerShell job step and simply call the file "X:\Scripts\File.ps1", it succeeds with no errors; however, the script doesn't appear to fire. What am I missing?
Thanks
April 3, 2017 at 11:46 am
OK, If I add a powershell.exe call to it and/or switch to a CmdExec, both now get me something to work off of.
Our scripts rely on modules, and via the Agent, the modules aren't loading:
The specified module 'DBACCollector' was not loaded because no valid module file was found in any module directory. At D:\DBA\Collectors\Collect-Jobs.ps1:10 char:1 + Import-Module DBACCollector -Force -Global + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : ResourceUnavailable: (DBACCollector:String) [Import-Module], FileNotFoundException + FullyQualifiedErrorId : Modules_ModuleNotFound,Microsoft.PowerShell.Commands.ImportModuleCommand. Process Exit Code 1. The step failed.
The modules are loaded to their default path %UserProfile%\Documents\WindowsPowerShell\Modules. Executing from a command line, works like a champ. I'm using the same account interactively from the server via command line, as is the calling account (via Proxy) from the Agent.
Any thoughts?
April 3, 2017 at 12:11 pm
Alrighty, so I found and modified the $env:PSModulePath to support a non default path for the modules to live. I moved my modules there, tested via command line, perfect.
Still can't get it to execute properly from an Agent job though. Hrm.
April 3, 2017 at 12:22 pm
OK, finally got it. Even though it's a job step of PowerShell, the combo I finally got to work was "powershell.exe -NoProfile -File "X:\File.ps1"
All set
April 4, 2017 at 5:08 am
Can you mark your own response as the answer?
Gaz
-- Stop your grinnin' and drop your linen...they're everywhere!!!
April 5, 2017 at 3:17 am
Thanks.
Gaz
-- Stop your grinnin' and drop your linen...they're everywhere!!!
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy