How to find the TFS scheduled jobs detail?

by XDK 22. October 2015 09:23

Solution: 

You can query the Job details tables in Tfs_Configuration

Query:

SELECT tbl_JobSchedule.JobId, tbl_JobSchedule.ScheduledTime, tbl_JobSchedule.Interval, 
tbl_JobSchedule.TimeZoneId, tbl_JobDefinition.JobName FROM tbl_JobDefinition 
RIGHT OUTER JOIN tbl_JobSchedule ON tbl_JobDefinition.JobId = tbl_JobSchedule.JobId

Output:
JobId ScheduledTime Interval (Sec) TimeZoneId JobName
C03C29A7-00AE-4E02-94BC-18ACA80E2EA2 7/16/08 3:00 AM 86400 UTC Team Foundation Server Image Cleanup
DD7629E4-66BB-45F9-AD42-2651BD7E56B8 7/3/11 8:00 AM 86400 UTC Team Foundation Server Send Email Confirmation Job
3C601170-8080-4A7D-B8E7-48E991F80C4A 7/16/08 3:00 AM 86400 UTC Team Foundation Server Application Tier Maintanence Job
B1516502-4633-432B-BDB3-74C802C5F2B7 7/3/11 9:00 AM 86400 UTC Team Foundation Server Send Mail Job
544DD581-F72A-45A9-8DE0-8CD3A5F29DFE 7/16/08 3:00 AM 3600 UTC Team Foundation Server Periodic Identity Synchronization
B19DDD28-9A95-42E2-9697-966FD822F1CD 7/3/11 10:08 PM 604800 UTC Prune Registry Audit Log
2ABF4FAB-5E36-4731-9E9F-9694C3CF0592 8/23/12 10:08 PM 86400 UTC File Container Cleanup
63A78C70-8FE0-4743-BA2D-A00CF8C20FDF 7/16/08 3:00 AM 86400 UTC Security Identity Cleanup Job
7A3E559E-8EB7-4E90-A4F7-B7A2515D52B9 7/3/11 9:00 AM 86400 UTC Team Foundation Server Framework File Service Cleanup
AF87E4CD-D421-4A24-BF16-D3A68371703E 7/20/08 3:00 AM 604800 UTC Team Foundation Server Database Optimization
8FC76967-DA5D-4D53-937B-E3EFC6AF0FCB 7/16/08 3:00 AM 86400 UTC Job History Cleanup Job
A4804DCF-4BB6-4109-B61C-E59C2E8A9FF7 7/3/11 8:00 AM 86400 UTC Team Foundation Server Event Processing
AD9C60AE-5BF0-4AC0-BE56-F2988088859A 7/16/08 3:00 AM 86400 UTC Team Foundation Server Activity Logging Administration
81A90003-CA23-4E55-9320-F956F62A2477 7/16/08 3:00 AM 86400 UTC Team Foundation Server Data Maintanence

 

Tags:

Azure DevOps on-premises | TFS 2012 | TFS 2013 | TFS 2015

E-Mail | Kick it! | DZone it! | del.icio.us
Permalink | Comments (0)
Comments are closed

About the author

My name is Xavier Dilip Kumar Jayaraj having 16+ years of IT experience which includes solid experience and depth Knowledge in Application Life Cycle Management, Configuration Management, Implementation and Support using TFS on-premises and Azure DevOps. I have invested in gaining DevOps knowledege to expertise with Cloud Computing providers namely Microsoft Azure and Amazon Web Services in recent years. I am very positive to learn and adapt emerging technologies to client’s environment.

Microsoft Certified: Azure Administrator Associate

Microsoft Certified: Azure DevOps Engineer Expert

DevOps Engineer Certificate Program | Transcript 

OTP-AWSD5: AWS IoT: Developing and Deploying an Internet of Things

[PCEP-30-01] PCEP – Certified Entry-Level Python Programmer

LinkedIn Profile

Knowledge Base Articles

Quotes I Like

"Failure will never overtake me if my determination to succeed is strong enough."  - Dr. APJ. Abdul Kalam

"Always be yourself, express yourself, have faith in yourself, do not go out and look for a successful personality and duplicate it." - Bruce Lee

"Technology is just a tool. In terms of getting the kids working together and motivating them, the teacher is the most important." - Bill Gates

"Innovation distinguishes between a leader and a follower." - Steve Jobs

CategoryList

Disclaimer

The information provided here is based on my expreriences, troubleshooting and online/offline findings. It can be used as is on your own risk without any warranties and I impose no rights.