devxlogo

December 28, 2018

Auto Start the SQL Server Agent Service

You can ensure that your SQl Server Agent always restarts when the SQL Server restarts by using sp_Configure and xp_cmdshell, as shown underneath: 1. Enabe ‘xp_cmdshell’ — Allow advanced options