# ------------------------------------------------------------------------------------------------------------------------ # What jobs are currently executing, running now? RUNNING JOBS $ExclusionList = @('SQLEXT1')# @() # # @() # @() # # $RunningJobs = Get-SQLExecutingJobs -AllServersList $AllServersList -ExclusionList $ExclusionList -ErrorAction Continue # -Verbose -WarningAction SilentlyContinue # Summarize $RunningJobs |Sort-Object ServerName | Select-Object RunDateTime, @{n="Duration ";e={ ("{0:dd\:hh\:mm\:ss}" -f (NEW-TIMESPAN –Start $_.RunDateTime –End (GET-DATE))) }}, ServerName, JobName,current_execution_step,last_run_date,last_run_time | Format-Table -autosize