March 11, 2019 at 6:57 am
I am wondering if someone help me fix this job.
Executed as user: ***** The job script encountered the following errors. These errors did not stop the script: A job step received an error at line 1 in a PowerShell script. The corresponding line is 'import-module SQLPS'. Correct the script and reschedule the job. The error information returned by PowerShell is: 'The specified module 'SQLPS' was not loaded because no valid module file was found in any module directory. ' A job step received an error at line 1 in a PowerShell script. The corresponding line is 'SQLSERVER:'. Correct the script and reschedule the job. The error information returned by PowerShell is: 'The term 'SQLSERVER:' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. '. Process Exit Code -1. The step failed.
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
March 11, 2019 at 7:37 am
Check whether the SQLPS Powershell module is located in the folder specified in the PSModulePath environment variable. If it isn't, either change the environment variable to the actual path of the module (requires server restart), or copy the module (you should find it somewhere under Program Files\Microsoft SQL Server) to the path specified in the environment variable.
John
March 11, 2019 at 7:53 am
John Mitchell-245523 - Monday, March 11, 2019 7:37 AMCheck whether the SQLPS Powershell module is located in the folder specified in the PSModulePath environment variable. If it isn't, either change the environment variable to the actual path of the module (requires server restart), or copy the module (you should find it somewhere under Program Files\Microsoft SQL Server) to the path specified in the environment variable.John
Thanks! Appreciate the help.
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply