• Ack! Posted before I was finished. The SQL Server Agent account should be a member of the local Administrators group for the autorestart function. I've run into to too many situations where the agent service dies for one reason or another and without the autorestart it can become serious very quick if you rely on any scheduled jobs for production operation.


    David R Buckingham, MCDBA,MCSA,MCP