SQL v2012. Unfortunately, I have always tasked the PowerShell efforts to staff members... I've never really had any hands-on before, and now I am having some problems invoking a script.
I am using the instructions from http://epmframework.codeplex.com/
, in the EPM Configuration Documentation v3.docx. I am in SSMS, connected to my CMS server, and have started PowerShell. I have attempted the first statement here, within the console, but it does nothing. The 2nd one works fine --
This does nothing -- No errors, no output, nothing:
>> SL "D:\directoryName\EPM_Ente
.0.ps1" -ConfigurationGroup "myGroupName" -PolicyCategoryFilter " " –EvalMode “Check”
Yet this works:
>>Invoke-Sqlcmd -Query "SELECT @@VERSION;" -QueryTimeout 3
As I said, the top one does nothing. I just carriage return to another line prefaced with the two carrots.
I'm surfing for all kinds of how-tos for powershell in SQL. I found this:
A 1/4 or so down, it says this:
By default, you wouldn't be able to execute scripts in Windows PowerShell due to the security policy.
Is that my problem? I have attempted to set the set-executionpolicy, but that also returns no response within the console.
I needed this darned thing done a week ago. Any instruction is appreciated. Hugely.