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