A simple timeline report for SQL Agent Job History from Get-DbaAgentJobHistory
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
Get-DbaAgentJobHistoryTimeline.ps1
LICENSE
README.md

README.md

sql-agent-timeline

A simple timeline report for SQL Server Agent Job history

You need dbatools.io to run this

to execute:

.\Get-DbaAgentJobHistoryTimeline.ps1 -DbaAgentJobHistory $(Get-DbaAgentJobHistory -SqlInstance SQLSERVER001 -StartDate ‘2018-08-07 20:00’ -EndDate ‘2018-08-08 20:00’ -NoJobSteps | ?{$(Get-Date $_.EndDate)-gt $(Get-Date $_.StartDate.AddMinutes(1))} )

details: https://marcin.gminski.net/goodies/sql-agent-jobs-timeline/