Grant Holliday's Blog - All Comments

re: TFS2010: Update Activity Logging Cleanup Interval

Grant Holliday - MSFT — Sun, 19 May 2013 04:59:47 GMT

@MagnusTim - It's stored in tbl_JobDefinition for each team project collection. It's not recommended/supported to change the database directly. But you should be able to work it out in this case.

re: TFS2010: Update Activity Logging Cleanup Interval

MagnusTim — Fri, 17 May 2013 07:05:44 GMT

Hi Grant,

Thanks for your answer! I guess we have to do it in another way then.

Is the update interval stored the registry or the database for TFS 2010 and TFS 2012?

/Magnus

re: TFS2010: Update Activity Logging Cleanup Interval

Grant Holliday - MSFT — Thu, 16 May 2013 13:45:28 GMT

@MagnusTim - Unfortunately this method no longer works once you have applied either TFS2010 SP1 + Security patch or upgraded to TFS2012. This was a security-related change to prevent a situation where a remote attacker can add/update a job to execute arbitrary SQL.

In TFS2012, you will receive the error: "TF400444: Jobs targeting the Microsoft.TeamFoundation.JobService.Extensions.Core.GenericSqlJobExtension extension can't be added or updated from the client. Only servicing operations running on the server can define these jobs."

This was a security-related change to prevent a situation where a remote attacker can add/update a job to execute arbitrary SQL.

I'm told that there is a change in >TFS2012 that will shift this cleanup interval setting to a TFS registry setting.

re: TFS2010: Update Activity Logging Cleanup Interval

MagnusTim — Thu, 16 May 2013 13:05:55 GMT

Hi Grant,

I have used this script before but for one of my customers I get this:

ForEach-Object : Exception calling "UpdateJob" with "1" argument(s): "Access Denied: tfssetup needs the following

permission(s) on the resource AllJobs to perform this action: Manage background jobs"

Do you have any suggestions? The setup account has TFS admin rights and we are using TFS 2010.

/Magnus

re: tf.exe: Unable to determine the workspace

Pradeep — Tue, 14 May 2013 08:44:33 GMT

I have 2 users mapped the same Server Path to Different Local Path, so how does the tf get understand which workspace to use to get the latest?

re: TFS2012: What are all the different Jobs built-in to TFS?

computerpaul — Wed, 08 May 2013 16:19:37 GMT

@Grant Holliday - I was specifically looking for the "Work Item Tracking Integration Synchronization" job

re: TFS2012: What are all the different Jobs built-in to TFS?

Grant Holliday - MSFT — Tue, 07 May 2013 11:43:44 GMT

@Computerpaul - Most of them are self-explanatory. Were there any in particular you wanted to know about?

Page 692 of the book I wrote describes some of the important ones. Grab yourself a copy at http://bit.ly/ProTFS2012

re: New book: Professional Team Foundation Server 2012

Grant Holliday - MSFT — Tue, 07 May 2013 11:31:02 GMT

@Mark - Yes, for Team Foundation Server Express - you would just ignore the chapters that relate to reporting, etc. The installation and administration process is the same for Express as it is for any other edition.

re: New book: Professional Team Foundation Server 2012

Mark Eckeard — Tue, 07 May 2013 11:24:25 GMT

Hi,

Would this book most of the express version as well?

Thanks,

Mark

re: TFS2012: What are all the different Jobs built-in to TFS?

computerpaul — Mon, 06 May 2013 20:11:48 GMT

Any chance of getting descriptions for what each of these jobs do, specifically "Work Item Tracking Integration Synchronization"?