Saturday, December 8, 2012

The SQL Server Agent Job 'syspolicy_purge_history' Is Failing

The SQL Server Agent Job 'syspolicy_purge_history' Is Failing

Error Details:
Executed as user: domain\Loginname. Unhandled Exception: System.IO.FileNotFoundException: Could not load file or assembly 'System.Management.Automation, Version=1.0.0.0, Culture=neutral, PublicKeyToken=12bf1234ad123e12' or one of its dependencies. The system cannot find the file specified.  File name: 'System.Management.Automation, Version=1.0.0.0, Culture=neutral, PublicKeyToken=12bf1234ad123e12'.  Process Exit Code -532459699.  The step failed.

There are many methods to resolve this issue, but I have succeeded to resolve this issue following these steps.

Workaround/MSSQLFix

Step 1: Right-click on syspolicy_purge_history, and then click Properties.

Step 2: Click Steps. 

Step 3: Select Erase Phantom System Health Records, and then click Edit in bottom.




Step 4: In the Command box, replace the computer node name by using the virtual server name for the cluster instance and Click OK, and then click Close.
"Suspended" Job - syspolicy_purge_history when trying to run. The syspolicy_purge_history SQL Server Agent job may fail in. Syspolicy_purge_history job in SQL Server. syspolicy_purge_history What is it. Why SYSPOLICY_PURGE_HISTORY job fails in SQL Server 2008. R2. sql server 2012. What does job syspolicy_purge_history do?. Syspolicy purge_history connection issue.

0 comments:

Post a Comment