Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

SQL Server Agent Job schedule & Execution timeline

Having a report or view of SQLAgent job schedules presented as a Gantt chart would be a very useful feature. There was a free tool SQLJobVis by sqlsoft.co.uk, which is now defunct, that would be a good prototype for such a feature. Being able to correlate job schedules and performance impacts, and visually seeing when job clash is occurring would be the main benefits.

1. Simple report of jobs/schedules. (I can provide query example/SSRS report.)

2. Calendar view of the various schedule types (daily, weekly, monthly, Yearly, etc.) that could also display the average duration for each job, highlighting any clash time.

3. Calendar view of job executions, showing actual duration and highlighting clash time.

Find more posts tagged with

Status: None

Comments

re.harmsen

This would be really helpfull in order to be able to more efficently schedule jobs and be able to see where room is for maintenance windows.