# ------------------------------------------------------------------------------------------------------------------------
# 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
