Powershell scripts fails when run through jobs

Question

Powershell scripts fails when run through jobs

Ryan007

SSCrazy Eights

Points: 8275
More actions
January 12, 2012 at 6:33 am

#254870

Hi,
I am running the below scripts through powershell window. It works fine.
PS SQLSERVER:\SQL\ITXXXXX-NBXXXX\DEFAULT> SL "C:\SUMANTA\PBM\CodePlex 3.0\1Down
Version Evaluation PS"
PS C:\SUMANTA\PBM\CodePlex 3.0\1Down Version Evaluation PS> .\EPM_EnterpriseEval
uation_3.0.0.ps1 -ConfigurationGroup "" -PolicyCategoryFilter "" -EvalMode ""
Security Warning
Run only scripts that you trust. While scripts from the Internet can be useful,
this script can potentially harm your computer. Do you want to run
C:\SUMANTA\PBM\CodePlex 3.0\1Down Version Evaluation
PS\EPM_EnterpriseEvaluation_3.0.0.ps1?
[D] Do not run [R] Run once Suspend [?] Help (default is "D"): R
Now to run this through job, I created a agent job and pasted the same code below under the type PowerShell
SL "C:\SUMANTA\PBM\CodePlex 3.0\1Down Version Evaluation PS\"
.\EPM_EnterpriseEvaluation_3.0.0.ps1 -ConfigurationGroup "" -PolicyCategoryFilter "" -EvalMode ""
But it fails and gives me the below error.
Message
Executed as user: ITXXXXX-NBXXXX\SYSTEM. A job step received an error at line 2 in a PowerShell script. The corresponding line is '.\EPM_EnterpriseEvaluation_3.0.0.ps1 -ConfigurationGroup "" -PolicyCategoryFilter "" -EvalMode ""'. Correct the script and reschedule the job. The error information returned by PowerShell is: 'AuthorizationManager check failed. '. Process Exit Code -1. The step failed.
Is there anything I am missing here? Please advice.
Ryan
//All our dreams can come true, if we have the courage to pursue them//

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Brandie Tarvin SSC Guru Points: 173108 More actions · Answer 1

I've never used Powershell, so I can't give you much help. Have you tried googling your error or parts of the error?

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Ryan007 SSCrazy Eights Points: 8275 More actions · Answer 2

Hi,

I found the solution. This was due the script was downloaded from the internet and it was blocked. so clicked the button to unblock.

http://epmframework.codeplex.com/workitem/4483

Thanks.

Ryan
//All our dreams can come true, if we have the courage to pursue them//

Brandie Tarvin SSC Guru Points: 173108 More actions · Answer 3

I'm glad you figured it out. Thank you for posting the solution so others can find it.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.