• Tony

    SMO might be overkill in this scenario:

    Get-Service -computer $ServerName SQLSERVERAGENT | Restart-Service

    • http://www.johnsansom.com John Sansom

      Hi Tony, that’s an excellent suggestion. Thanks for raising it! Off to run some tests…..

    • http://www.johnsansom.com John Sansom

      The post has been updated to reflect your suggestion sir, thanks again.