Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

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

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, April 07, 2014 7:59 AM
Points: 8, Visits: 60
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