TFS 2010:The host cannot be started. the host is in the process of being serviced

Hi,

Today i have received Error this "The host cannot be started. the host is in the process of being serviced " in my TFS 2010 server. while I try to start My Team Project Collection in  TFS.

After research  bit of time. In my Team foundation Administrator console  I have notice that

Under the Status Tab Some Jobs are in Queued status.


Now I understand that after stop/Delete this queue i can be able to start the same. So friends, Herewith i am sharing you the details workaround which i have come up with the success.


1. Jobs are be stored in the " tbl_JobQueue " table of the TFS_Configuration Database so I used below statement in SQL.

In this statement i have viewed the table first and  i have note the priority of the above mentioned jobs which are in the queue.

/--------Sql Statement for View the Table-----/

SELECT *
  FROM [Tfs_Configuration].[dbo].[tbl_JobQueue]

In this statement i have deleted the records where the priority column contains value 1.

/--------Sql Statement for Delete the records in table where the condition match-----/

DELETE FROM [Tfs_Configuration].[dbo].[tbl_JobQueue]
  where Priority = '1'


After completed the above steps i have closed Team foundation Administrator console once and reopened.

3. Make sure that thejob status should be failed .
4.. Now i have stared the team project collection and it's worked.

If you find this is useful then please drop your comments.

Thanks
R.karthikeyan