Friday, August 19, 2016

PowerShell - Display SQL Agent Jobs

Import-Module SQLPS -DisableNameChecking

$instanceName = "server2"
$server = New-Object -TypeName Microsoft.SqlServer.Management.Smo.Server -ArgumentList $instanceName

$jobs = $server.JobServer.Jobs

$jobs | Select-Object Name, OwnerLoginName, LastRunDate, LastRunOutcome | Sort-Object -Property Name | Format-Table -AutoSize