Our server hosting SQL Server 2008 is set to reboot nightly. Recently it developed following problem: after server reboot SQL Server 2008 agent won't start sometimes. Doesn't happen all the time but about once a week. Causes obvious problems because jobs don't run when scheduled until someone notices and starts it manually. Agent runs under domain account. Same domain account is used for the rest of SQL Server services and they all start fine, including database engine.
1) Anybody has any idea what the problem might be and how to fix it?
2) In Services Manager one can set up service to restart after first and/or second and/or subsequent failures. Is this a good idea to use this functionality as a workaround? If I use this - is there any logging so that later I can see that startup failure has occurred?