SQL Agent Insights:Roadmap: Difference between revisions

From SQL Agent Insights Wiki
No edit summary
Line 5: Line 5:


== In Development / Researching ==
== In Development / Researching ==
=== New ===
* {{RoadmapSpanNewColor}}'''N210330-1'''</span> : Azure SQL managed instance support
* {{RoadmapSpanNewColor}}'''N210330-1'''</span> : Azure SQL managed instance support
* {{RoadmapSpanNewColor}}'''N210821-1'''</span> : Insight : new job metric showing successful jobs that have failed steps in the history.
* {{RoadmapSpanNewColor}}'''N210913-1'''</span> : UI : implement column chooser for all data grids with a significant number of columns with ability to save layout.
=== Enhancement/Improvement ===
* {{RoadmapSpanEnhanceColor}}'''E210228-3'''</span> : convert entire SQL Agent Insight project to .NET 6
* {{RoadmapSpanEnhanceColor}}'''E210228-3'''</span> : convert entire SQL Agent Insight project to .NET 6
* {{RoadmapSpanNewColor}}'''N210821-1'''</span> : Insight : new job metric showing successful jobs that have failed steps in the history.
* {{RoadmapSpanEnhanceColor}}'''E210725-1'''</span> : Preferences : omit asking to create suspend/resume jobs when opening Job Monitor.
* {{RoadmapSpanEnhanceColor}}'''E210725-1'''</span> : Preferences : omit asking to create suspend/resume jobs when opening Job Monitor.
* {{RoadmapSpanNewColor}}'''N210913-1'''</span> : UI : implement column chooser for all data grids with a significant number of columns with ability to save layout.


== Future Considerations ==
== Future Considerations ==
=== New ===
* {{RoadmapSpanNewColor}}'''N210818-1'''</span> : Job Monitor : a single instance of Job Monitor that consolidates all jobs from all currently monitored instances.
* {{RoadmapSpanNewColor}}'''N210818-1'''</span> : Job Monitor : a single instance of Job Monitor that consolidates all jobs from all currently monitored instances.
* {{RoadmapSpanEnhanceColor}}'''E200602-2'''</span> : Job Monitor : new metrics including, ''has steps'', ''no history'', ''success rate < 100%'', ''successful job runs with failed job steps'', ''has alerts'', ''has targets'', ''ms-db backup size'', ''ms-db compressed backup size'', ''number of deleted jobs since last poll''.
** ''number of deleted jobs since last poll'' would additionally log the names of jobs missing.
* {{RoadmapSpanNewColor}}'''N210111-1'''</span> : Preferences : email authentication via OAuth2.
* {{RoadmapSpanNewColor}}'''N210111-1'''</span> : Preferences : email authentication via OAuth2.
* {{RoadmapSpanNewColor}}'''N201014-1'''</span> : Job History : Gantt chart similar to Job Conflicts but for Job History.
* {{RoadmapSpanNewColor}}'''N201014-1'''</span> : Job History : Gantt chart similar to Job Conflicts but for Job History.
** user selectable jobs; Gantt chart timeframe based on earliest job history log entry.
** user selectable jobs; Gantt chart timeframe based on earliest job history log entry.
* {{RoadmapSpanEnhanceColor}}'''E210112-1'''</span> : Insight Log : row header icons for long running jobs.
* {{RoadmapSpanEnhanceColor}}'''E170517-1'''</span> : Job Conflicts : additional context menu items, ''job history''.
* {{RoadmapSpanEnhanceColor}}'''E200612-3'''</span> : Job History : access job properties.
* {{RoadmapSpanNewColor}}'''N181004-1'''</span> : Database Mail : purging of database mail items and mail log history.
* {{RoadmapSpanNewColor}}'''N181004-1'''</span> : Database Mail : purging of database mail items and mail log history.
* {{RoadmapSpanNewColor}}'''N171010-2'''</span> : Job Monitor : copy a job(s) between monitored SQL instances.
* {{RoadmapSpanNewColor}}'''N171010-2'''</span> : Job Monitor : copy a job(s) between monitored SQL instances.
Line 27: Line 25:
** implement globally with configuration option to override per Insight.
** implement globally with configuration option to override per Insight.
* {{RoadmapSpanNewColor}}'''N200822-1'''</span> : Insight : open the Job Monitor upon opening the Insight.
* {{RoadmapSpanNewColor}}'''N200822-1'''</span> : Insight : open the Job Monitor upon opening the Insight.
* {{RoadmapSpanEnhanceColor}}'''E210103-1'''</span> : Insight Log : buttons similar to Log Viewer to filter entries based on severity.
* {{RoadmapSpanNewColor}}'''N210510-1'''</span> : Job Monitor : change owner of a job or multiple jobs.
* {{RoadmapSpanNewColor}}'''N210510-1'''</span> : Job Monitor : change owner of a job or multiple jobs.
* {{RoadmapSpanNewColor}}'''N210610-1'''</span> : Job Conflicts : a single instance of Job Conflicts that consolidates all jobs from all currently monitored instances.
* {{RoadmapSpanNewColor}}'''N210610-1'''</span> : Job Conflicts : a single instance of Job Conflicts that consolidates all jobs from all currently monitored instances.
* {{RoadmapSpanNewColor}}'''N210706-2'''</span> : Job Monitor : additional column, ''Number of Alerts''.
* {{RoadmapSpanNewColor}}'''N210706-2'''</span> : Job Monitor : additional column, ''Number of Alerts''.
* {{RoadmapSpanNewColor}}'''N210706-1'''</span> : Schedules : new context menu with options, ''Job properties'', ''Job history'', ''Purge job history''.
* {{RoadmapSpanNewColor}}'''N210706-1'''</span> : Schedules : new context menu with options, ''Job properties'', ''Job history'', ''Purge job history''.
=== Enhancement/Improvement ===
* {{RoadmapSpanEnhanceColor}}'''E200602-2'''</span> : Job Monitor : new metrics including, ''has steps'', ''no history'', ''success rate < 100%'', ''successful job runs with failed job steps'', ''has alerts'', ''has targets'', ''ms-db backup size'', ''ms-db compressed backup size'', ''number of deleted jobs since last poll''.
** ''number of deleted jobs since last poll'' would additionally log the names of jobs missing.
* {{RoadmapSpanEnhanceColor}}'''E210112-1'''</span> : Insight Log : row header icons for long running jobs.
* {{RoadmapSpanEnhanceColor}}'''E170517-1'''</span> : Job Conflicts : additional context menu items, ''job history''.
* {{RoadmapSpanEnhanceColor}}'''E200612-3'''</span> : Job History : access job properties.
* {{RoadmapSpanEnhanceColor}}'''E210103-1'''</span> : Insight Log : buttons similar to Log Viewer to filter entries based on severity.


== Ready for Next Release ==
== Ready for Next Release ==
=== Version 0.24 ===
=== Version 0.24 ===

Revision as of 21:21, 20 October 2021

Interested in knowing what I'm working on or thinking of implementing for the next version of SQL Agent Insight? Read more below.

Legend

In Development / Researching

New

Enhancement/Improvement

Future Considerations

New

Enhancement/Improvement

Ready for Next Release

Version 0.24