When we restart the Team Foundation Server(The AT box, on a dual tier server), Visual Studio Team Foundation Server Task Scheduler service might not start automatically even if it is set to start automatically
To resolve this issue make the SQL Server Agent a dependency to Visual Studio Team Foundation Server Task Scheduler Service.
To do this, go to the registry editor and add a Multi-String Value to the corresponding service entry:
Start | Run | Regedit
Right click “New Multi-String Value”
Value: SQLAgent (you will have to mentioned SQL Server Name/Instance Name)
Content by: Romitg
Reviewed by: Lucky