Difference between revisions of "SQL Agent Insight:Roadmap"

From Brentec Wiki
Jump to navigation Jump to search
Line 1: Line 1:
Interested in knowing what I'm working on or thinking of implementing for the next version of SQL Agent Insight? Read more below.
Interested in knowing what I'm working on or thinking of implementing for the next version of SQL Agent Insight? Read more below.
== Legend ==
* {{RoadmapSpanNewColor}}'''New'''</span> feature/option.
* {{RoadmapSpanEnhanceColor}}'''Enhancement'''</span> to existing feature/option.


== In Development / Researching ==
== In Development / Researching ==
Line 9: Line 6:
* {{RoadmapSpanNewColor}}'''N210821-1'''</span> : Insight : new job metric showing successful jobs that have failed steps in the history.
* {{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.
* {{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 ===
=== 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
* {{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.
Line 30: Line 27:
* {{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 ===
=== 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''.
* {{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.
** ''number of deleted jobs since last poll'' would additionally log the names of jobs missing.

Revision as of 21:40, 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.

In Development / Researching

New

  • N210330-1 : Azure SQL managed instance support
  • N210821-1 : Insight : new job metric showing successful jobs that have failed steps in the history.
  • N210913-1 : UI : implement column chooser for all data grids with a significant number of columns with ability to save layout.

Enhancement / Improvement

  • E210228-3 : convert entire SQL Agent Insight project to .NET 6
  • E210725-1 : Preferences : omit asking to create suspend/resume jobs when opening Job Monitor.

Future Considerations

New

  • N210818-1 : Job Monitor : a single instance of Job Monitor that consolidates all jobs from all currently monitored instances.
  • N210111-1 : Preferences : email authentication via OAuth2.
  • N201014-1 : 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.
  • N181004-1 : Database Mail : purging of database mail items and mail log history.
  • N171010-2 : Job Monitor : copy a job(s) between monitored SQL instances.
  • N190802-1 : Job Monitor : multi-row selection of jobs to perform actions against selected jobs.
  • N200827-2 : Preferences/Insight Config : notification quiet hours/days.
    • implement globally with configuration option to override per Insight.
  • N200822-1 : Insight : open the Job Monitor upon opening the Insight.
  • N210510-1 : Job Monitor : change owner of a job or multiple jobs.
  • N210610-1 : Job Conflicts : a single instance of Job Conflicts that consolidates all jobs from all currently monitored instances.
  • N210706-2 : Job Monitor : additional column, Number of Alerts.
  • N210706-1 : Schedules : new context menu with options, Job properties, Job history, Purge job history.

Enhancement / Improvement

  • E200602-2 : 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.
  • E210112-1 : Insight Log : row header icons for long running jobs.
  • E170517-1 : Job Conflicts : additional context menu items, job history.
  • E200612-3 : Job History : access job properties.
  • E210103-1 : Insight Log : buttons similar to Log Viewer to filter entries based on severity.

Ready for Next Release

Version 0.24