Post reply

SQLPS and syspolicy_purge_history job

  • October 22, 2025 at 3:04 pm

    #4676418

    The SQLPS.exe file has gone AWOL on 2 of my 4 SQL servers, ie, not in the path

    select Agent_exe 

    from msdb.dbo.syssubsystems
    where subsystem = 'PowerShell'​

    nor anywhere to be found on these machines.

    As a result, syspolicy_purge_history fails. And in fact, the job's status is "suspended", and I can't even stop it. I am not able to stop and re-start the SQL Agent service, due to the job being suspended.

    Any ideas?

     

     

Viewing post 1 (of 1 total)

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