Show the status of the TFS jobs on a database server

 It's a very simple use of SMO, and there's much more you could do with this, but I wanted to get a very simple example out there.
 Yes, PowerShell + SMO is a great match.
 PS C:\> get-tfsdbjobs tkbgitvstfdt01 | ft -a

Name                                       CurrentRunStatus LastRunDate
----                                       ---------------- -----------
TFS WorkitemTracking Full Text Crawl Job               Idle 8/29/2006 12:10:00 PM
TfsActivityLogging Administration Job                  Idle 8/29/2006 12:00:00 AM
TfsIntegration Maintenance Job                         Idle 8/27/2006 12:00:00 AM
TFSVersionControl Administration Job                   Idle 8/29/2006 12:00:00 AM
TfsWorkItemTracking Process Identities Job             Idle 8/29/2006 12:10:00 PM
 param (
    [string] $serverName = $(throw 'serverName param is a required parameter'),
    [string] $matchString = 'TFS'
)

[void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.ConnectionInfo")
[void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo")

$server = new-object "Microsoft.SqlServer.Management.Smo.Server" $serverName

$server.JobServer.Jobs | ?{ $_.Name -match $matchString } | select Name,CurrentRunStatus,LastRunDate

get-tfsdbjobs.ps1