Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

In one of my SQL Server 2008 sp1 standalone instances, syspolicy_purge_history job is fails at step 3 Erase Phantom System Health Records.

Below is the command -

(Get-Item SQLSERVER:\SQLPolicy\servername\DEFAULT).EraseSystemHealthPhantomRecords()

Error :

Executed as user: domain\xxxxx. The process could not be created for step 3 of job 0x3183E8EEDE9C3A4DA0F20ABD41B573DC (reason: %1 is not a valid Win32 application). The step

Service account is same for SQL Server and Agent and it is admin on the server. I'm aware that clustered instances usually fail because of virtual name mismatch but I tried searching Google but I don't see correct solution to this problem.

share|improve this question
Are you running 32-bit SQL Server on a 64-bit OS? – Aaron Bertrand Jul 15 '14 at 19:04
Is there a file named Program in your systemdrive? – Jens W. Aug 31 '15 at 13:01

I ran into this error a while back and found this link, hope it resolves your issue.

share|improve this answer
Thanks Jeff, but this is a standalone server...still i'm getting the same error... – Robin16 Jul 16 '14 at 14:31
Are you able to run this script manually using powershell commandline? – SQLPRODDBA May 31 at 5:04

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.