March 14, 2013 at 7:28 am
Hi All -
I'm a new DBA. Trying to create a sql job that evaluates policies against our cms. I have it working locally going against our test cms. When I move the job up to a test server, the first step of the job bombs on the first line of the powershell script:
--
Error Message
The corresponding line is 'import-module sqlps -DisableNameChecking'. Correct the script and reschedule the job. The error information returned by PowerShell is: 'The term 'import-module' is not recognized as the name of a cmdlet, function, script file, or operable program.
--
I am using a proxy for this step and I have researched it trying several different solutions. Any suggestions or hints on how to get sqlps imported successfully within a powershell job step? I cannot run scripts from steps, so that is out.
Thanks in advance.
Viewing 0 posts
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