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