Can't find TfsVersionControl Administration Job

Question

im using tfs 2017 update 3; i want reduce my tfs database size; so i want clean up it; i cant find TfsVersionControl Administration Job in job list and when i run this code : use [msdb]; go

    select
       CAST (name as varchar(60)) as job_name,
       job_id,
       enabled
    from 
       sysjobs
    order by
          name;
    go

i cant see any job; i searched about it and i find a little information about this; can i deploy this job manually ??? how????

Answer 1

TFS VersionControl Administration Job is obsolete since TFS2010, so you could not find it, because TFS 2017 does not use it.

Visual Studio Team Foundation Background Job Agent windows service is installed with TFS server on the application tier and executes maintenance jobs on all TFS databases.

If you want to reduce your tfs database size, there are a couple of ways to clean your TFS database:

• tf destroy command
• Test Attachment Cleanup Tool
• witamin (destroying work items)

You could also reference this blog to reduce the TFS database size. Another way is shrinking the transaction log in TFS. How to do it please take a look at this answer.