Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

powershelling against cms - problems in test Expand / Collapse
Posted Thursday, March 14, 2013 7:28 AM


Group: General Forum Members
Last Login: Thursday, September 1, 2016 11:33 AM
Points: 16, Visits: 130
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.
Post #1430956
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse