tfs incremental analysis database sync job

gistfile1.sql

-- Find the job schedule
SELECT
	JobName
	,ScheduledTime
	,Interval
FROM tbl_JobDefinition jd
	INNER JOIN tbl_JobSchedule js ON jd.JobId = js.JobId
WHERE
	JobName = 'Incremental Analysis Database Sync'

-- Find the next job in the queue
SELECT
	*
FROM tbl_JobQueue jq
	INNER JOIN tbl_JobDefinition js ON jq.JobId = js.JobId
WHERE
	JobName = 'Incremental Analysis Database Sync'